Kbase P101111: How to setup an ODBC.INI file for more than one SQL-92 database connection
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/25/2009 |
|
Status: Verified
GOAL:
How to setup an ODBC.INI file for more than one SQL-92 database connection
GOAL:
How to connect to multiple databases using SQL-92 on UNIX
GOAL:
Can a ODBC.INI file contain more than one DSN entry
FACT(s) (Environment):
UNIX
Progress 9.1x
OpenEdge 10.x
FIX:
To connect to multiple databases using SQL-92 on UNIX, follow the steps below:
1. Create a separate DSN entry for each database in the ODBC.INI file.
2. Start a broker for each database entry, making sure each broker runs on a unique port number.
For example:
[ODBC Data Source]
DB1=Progress_SQL92_Driver
DB2=Progress_SQL92_Driver
[db1odbc]
Driver=/usr/dlc/odbc/lib/pgpro915.so
DatabaseName=DB1
Portnumber=5555
Hostname=Prog1
LogonID=sysprogress
Password=sysprogress
APILevel=1
ConnectFunctions=YYN
CPTimeout=60
DriverODBCVer=03.60
FileUsage=0
SQLLevel=0
UsageCount=1
ArraySize=50
DefaultLongDataBuffLen=2048
DefaultIsolationLevel=REPEATABLE READ
StaticCursorLongColBuffLen=4096
[DB2odbc]
Driver=/usr/dlc/odbc/lib/pgpro915.so
DatabaseName=DB2
Portnumber=6666
Hostname=PROG2
LogonID=sysprogress
Password=sysprogress
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]
InstallDir=/usr/dlc/odbc
Trace=1
TraceFile=/tmp/odbctrace.out
TraceDll=/usr/dlc/odbc/lib/odbctrac.so
UseCursorLib=0