Error Problems when test ODBC Driver´s on Progress

Frederick

New Member
Hi, sorry for my english. My name is Federico from Argentina.

Enviroment:

Linux Opensuse 10.2
Openedge 10.1b

Ineed test on local pc with linux the connection trough ODBC drivers located in /usr/dlc/odbc/lib...

I´follow this steps http://knowledgebase.progress.com/articles/Article/P21252?popup=true......

but when executed demoodbc my test show an error message.

"System information not found. Please check the ODBC enviroment variable".

I´created the ODBCINI, ODBINST and LD_LIBRARY_PATH with the absolute path ...

Some help??

Thanks
 

Frederick

New Member
Hi this is mi odbc.ini in /usr/dlc/odbc

the db is running by proserve -H -N -S and the port 30080 are listening

[ODBC Data Sources]
;mytest is the Data Source Name (DSN) and could be any name you choose. Each DSN should be unique.
;you can have multiple data sources. For each one you should create a configuration section below.
mytest=prueba

[mytest]
; Driver is the path to the shared library containing the Progress driver.
; Replace with the complete path to your version of the ODBC driver in $DLC/odbc/lib.
; The shared library is named after the following pattern:
; pgpro9XX.so - Progress 9 driver
; pgoe10XX.so - OpenEdge 10 driver
Driver=/usr/dlc/odbc/lib/pgoe1022.so

DatabaseName=prueba
; PortNumber is the port number where the SQL broker is listening. If you don't use separate brokers
; for 4GL and SQL, this is the same port number as the -S parameter.
PortNumber=30080
; HostName is the name of the host where the database server is running. Use "localhost" if
; the database is running locally. This setting should match database parameter -H.
HostName=192.168.1.3
; LogonID can be an account set up for the database if security is enabled.
; You may also use your logon account with the password blank.
; The default SQL dba is the user who created the database.
; This account should be used to gain full access to tables and users for the SQL part of the database.
LogonID=sysprogress
Password=sysprogress

; The default values for the following options are acceptable in most configurations. Refer
; to the documentation if you need to change them.
APILevel=1
ConnectFunctions=YYN
CPTimeout=60
DriverODBCVer=03.60
FileUsage=0
SQLLevel=0
UsageCount=1
ArraySize=50
DefaultLongDataBuffLen=2048
DefaultIsolationLevel=REPEATABLE READ
StaticCursorLongColBuffLen=4096

[ODBC]
; the ODBC section is generic and not specific to Progress/OpenEdge. It pertains to
; the standard ODBC framework (shared among ODBC drivers).
; A copy of the standard ODBC framework libraries is included with Progress/OpenEdge;
; use th.is if you do not have another ODBC environment already in use on the system.

; InstallDir is the root path to the ODBC framework. $DLC/odbc is not an acceptable path, use the absolute path..
InstallDir=/usr/dlc/odbc
; Use Trace=1 to enable an ODBC trace. This requires a path to a log file (TraceFile)
; and a path to a tracing library (included with Progress/OpenEdge in $DLC/lib/odbctrac.so, be sure to use the absolute path in the configuration)
Trace=1
TraceFile=/tmp/odbctrace.out
TraceDll=/usr/dlc/odbc/lib/odbctrac.so
UseCursorLib=0


Somebody help me!!!!
 
Top