Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reserved error -7778 - ODBC connection to IBM DB2 ODBC DRIVER

Status
Not open for further replies.

mwarhol

Programmer
Oct 16, 2001
2
US
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.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top