By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,721 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

CLI problem

P: n/a
we connect to a db2 datasource from our app using ODBC. On most
machines this connection works fine but on a couple of machines we get
an error: SQL1013N database "" does not exist. The machines where I
can produce the problems are at the same fixpak level as the error
free machines (8.1.5)

I stepped through the code on one of the problem machine and also took
a CLI trace and found that somehow db2 was rewriting the connect
string that our program was sending it:

our connect string:
"DRIVER={IBM DB2 ODBC DRIVER};DSN=SAMPLE;UID=db2admin;PWD=password;"

Connect string in the cli trace (note the missing DSN):
"DRIVER={IBM DB2 ODBC DRIVER};UID=db2admin;PWD=********;"
CLI trace snippet:
SQLDriverConnectW( hDbc=0:1, hwnd=0:0, szConnStrIn="DRIVER={IBM DB2
ODBC DRIVER};UID=db2admin;PWD=********;", cbConnStrIn=-3,
szConnStrOut=&01c81918, cbConnStrOutMax=1024, pcbConnStrOut=&0012bcac,
fDriverCompletion=SQL_DRIVER_NOPROMPT )
---> Time elapsed - +2.700000E-005 seconds
( Unretrieved error message="CLI0005W Option value changed.
SQLSTATE=01S02" )

Any help will be appreciated..
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.