| Message: 60696 |
 |
BY: Praveen Devarao (praveend)
DATE: 2008-09-24 12:02
SUBJECT: RE: Connection fails with no Error Msg Hi Steven,
Thanks for writing. First of all let me tell you that the ibm_db driver talks to DB2 through CLI, which is an implementation of ODBC. Hence this is different from JDBC, using which you connected to the database successfully.
Coming to the problem that you are facing. Your DB2INSTANCE environment(env) variable is not set properly, this can be made out from the error message,[SQL10007N Message "-1390" could not be retrieved. Reason code: "3"]. To solve this set the env variable DB2INSTANCE to the appropriate instance.
export DB2INSTANCE=<your_instance_name>
To get the list of instances on your machine issue the command db2ilist and set the DB2INSTANCE variable to the appropriate value.
Let me know if this solves the problem.
Thanks,
Praveen | |
Start New Thread
Connection fails with no Error Msg