If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 ODBC binding error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-28-04, 13:13
dsusendran dsusendran is offline
Registered User
 
Join Date: Apr 2004
Location: Inside Intel
Posts: 165
Angry DB2 ODBC binding error

Hi all,

I am trying to make a connection through ODBC connection to the DB2 database with one of our applications. I got the following error message :

Error Messages:
[IBM][CLI Driver][db2/NT] SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES")has returned an error SQLSTATE with diagnostic "SYSIBM:CLI:-805", SQLSTATE=38553

DB2 Version: DB2 connect edition 8.1.5 (fixpak 5 applied)
Operating System: Windows 2000 Server (Service pack 4)

I am a newbie and i dont know how to interpret this error message. I did a google search and seems that no one has had this error before. Any suggestions is really appreciated. Thanks in advance.

Newbie
Reply With Quote
  #2 (permalink)  
Old 04-28-04, 13:59
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
Open your db2 configuration assistant, select the database name , right-click and then bind ..

Select all the packages listed and do a bind ...

HTH

Sathyaram
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #3 (permalink)  
Old 04-28-04, 14:31
dsusendran dsusendran is offline
Registered User
 
Join Date: Apr 2004
Location: Inside Intel
Posts: 165
Angry

Hi,

Thanks for the prompt reply. I did go to the Configuration Assistant and tried to add "db2cli.lst". I got the following error.


"SQL0031C File "C:\Program Files\IBM...bnd\db2cli.lst\db2clipk.bnd" could not be opened.

SQL0031C File "C:\Program Files\IBM...bnd\db2cli.lst\db2clist.bnd" could not be opened.

SQL30082N Attempt to establish connection failed with security reason "17" ("UNSUPPORTED FUNCTION"). SQLSTATE=08001

Bind completed with errors and/or warnings."

I tried connecting as Administrator. Thanks.

Newbie
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On