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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC connection

Status
Not open for further replies.

cgillin

Programmer
Mar 20, 2003
58
US
Hi

I'm using unixodbc to connect to a DB2 v8.1 db. I get the following error when trying to connect to the database..

[unixODBC][IBM][CLI Driver] SQL1031N The database directory cannot be found on
the indicated file

I created the sample database and can connect to it, but when trying to bind I get the following error...

SQL0031C File "/opt/db2inst5/sample.bnd" could not be opened.

and the process stops.

Is a failure to bind the cause of the odbc error I'm encountering? Also, does anyone have an idea why sample.bnd would not be in that directory or where else sample.bnd would be located?

Thanks
 
To clerify, I create the database on the server running DB2. From that same machine I can connect to the database by using...

db2 => connect to sample

But when I try to bind the database on that machine by using...

db2 => bind sample.bnd

is where I encounter the error.

Thanks again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top