Connection problem from Unix odbc to progress

Tonyhth

New Member
I encounter a problem when I connect to progress database by Unix odbc. We have 2 progress Databases(name them as A,B) inside same box which were setup with same DBName,portnumber. but use different database path ( exmple: /disk01/A & /disk03/B )for physical datbase file.

when I try to use odbc in unix to connect to Progress server, it looks like always connect to A , I can't figure out the way to connect it to B.
as I can't find any configuration item in odbc.ini to setup the database path. it only had DatabaseName. but unfortunately they setup the Progress database A & B both use same Name. but in Windows by Sequelink ODBC , I can setup the Database path (/disk01/B) which point directly to Database B.


Sample ODBC.ini

[ODBC Data Sources]
sports=Progress_SQL92_Driver
[sports]
Driver=[[install-dir]]/odbc/lib/pgpro915.s
DatabaseName=default
PortNumber=2055
HostName=localhost
LogonID=testuser
Password=xxx
APILevel=1
ConnectFunctions=YYN
CPTimeout=60
DriverODBCVer=03.60
FileUsage=0
SQLLevel=0
UsageCount=1
ArraySize=50
DefaultLongDataBuffLen=2048
DefaultIsolationLevel=REPEATABLE READ
LogonID=lovas
StaticCursorLongColBuffLen=4096

Any body can help me out ? Many Thanks.
 
Back
Top