VB5.0 - DAO3.5: DSN-less ODBC connection to IBM DB2 ODBC DRIVER
Results in: "Reserved error -7778"
Using the following connection string:
ODBC;driver={IBM DB2 ODBC DRIVER};UID=administrator;PWD=navisys;PROTOCOL=TCPIP;HOSTNAME=NJED499FS17;DATABASE=FODB2TS2;SERVICENAME=50000
Any modification of this connection string
(i.e. change SERVICENAME, DATABASE, PROTOCOL to another value)
ends up generating a "Run-time error '3146' ODBC call failed error" so I'm guessing
the first connection string is getting somewhere just not completing the connect.
With just this connection string:
ODBC;driver={IBM DB2 ODBC DRIVER}
The ODBC window comes up and I can fill in the DB, user and pwd it does connect.
Any idea what I could be missing here? I have no idea how to proceed.
Results in: "Reserved error -7778"
Using the following connection string:
ODBC;driver={IBM DB2 ODBC DRIVER};UID=administrator;PWD=navisys;PROTOCOL=TCPIP;HOSTNAME=NJED499FS17;DATABASE=FODB2TS2;SERVICENAME=50000
Any modification of this connection string
(i.e. change SERVICENAME, DATABASE, PROTOCOL to another value)
ends up generating a "Run-time error '3146' ODBC call failed error" so I'm guessing
the first connection string is getting somewhere just not completing the connect.
With just this connection string:
ODBC;driver={IBM DB2 ODBC DRIVER}
The ODBC window comes up and I can fill in the DB, user and pwd it does connect.
Any idea what I could be missing here? I have no idea how to proceed.