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

[mwarhol]

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;HOSTNAM
E=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.

 

[ETID]

I've gotten the same error trying to connect using a file DSN,... the file DSN works in Excel but not access, but the user and system DSNs both work fine, but I've only done read only with them.

Oh yeah I'm using the client access ODBC driver,...IBM says it's Microsoft's fault...and the Ms Office web site seems to at least admit there is a prblem, but not much in the way of a solution.

 

[Guest_imported]

MS Access cannot correctly use a file dsn to connect to via odbc.. which is very bad when you have multiple computers accessing one database... you have to install a system or user dsn on each machine that wants to access the data source.

the only solution is to create a system or user dsn instead of a file dsn :-(

this happens with all odbc drivers i've used (IBM AS400, MySQL, and others...)