Kbase P51300: How to configure odbc.ini and odbcinst.ini?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to configure odbc.ini and odbcinst.ini Linux.
GOAL:
Access a Progress database on Linux via ODBC from a Linux client.
FIX:
How to configure odbc.ini and odbcinst.ini Linux.
A sample of an odbcinst.ini file:
---------------------------------
[ODBC Drivers]
Progress = Installed
[ODBC Connection Pooling]
PerfMon = 0
Retry Wait =
[Progress]
Driver = /progress/dlc/odbc/lib/pgpro915.so
Setup = /progress/dlc/odbc/lib/pgpro915.so
APILevel = 1
CPTimeout = 60
ConnectFunctions = YYN
DriverODBCVer = 03.60
FileUsage = 1
SQLLevel = 0
UsageCount = 1
A sample of an ODBC.INI file:
-----------------------------
[ODBC Data Sources]
results=Progress_SQL92_Driver
[results]
Driver=/dlc/odbc/lib/pgproxx.so
DatabaseName=testdb
PortNumber=sqlservicename
HostName=myserverhost
LogonID=mylogin
Password=xxx
APILevel=1
ConnectFunctions=YYN
CPTimeout=60
DriverODBCVer=03.60
FileUsage=0
SQLLevel=0
UsageCount=1
ArraySize=50
DefaultIsolationLevel=REPEATABLE READ
LogonID=ccall
StaticCursorLongColBuffLen=4096
[ODBC]
InstallDir=/dlc/odbc
Trace=0
TraceFile=odbctrace.out
TraceDll=/dlc/odbc/lib/odbctrac.so
UseCursorLib=0
Note: Having space character (' ') in the odbc.ini file might make the connection fail.