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 > Error while creating DSN using DB2 ODBC Driver

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-04-09, 08:20
sachuu sachuu is offline
Registered User
 
Join Date: Jun 2009
Posts: 5
Question Error while creating DSN using DB2 ODBC Driver

Hi All,
We had two databases up and running on DB2 server. We created third one without any issues on the server. From another server (IIS server) we want to connect to this new database so we tried creating DSN on IIS server. The DSN creation is resulting in following error

SQL0969N There is no message text corresponding to SQL error "-3000" in the message file on this workstation. The error was returned from module "cfgCLIcn" with original tokens "76 "

We tried recreating existing DSN even they are resulting in error now.

This is for DB2 8.1 and we also found following errors in the log file of db2 client which is installed on IIS server

2009-06-03-19.00.59.318000-300 I31135H273 LEVEL: Error
PID : 5660 TID : 888 PROC : odbcad32.exe
INSTANCE: DB2 NODE : 000
APPID : OB3DE0B4.G009.019943235938
MESSAGE : Sqlcode
DATA #1 : String, 10 bytes
SQL -1005

2009-06-03-19.11.48.392000-300 I31410H347 LEVEL: Warning
PID : 5660 TID : 888 PROC : odbcad32.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, Client Config, cfgDB::catalog, probe:5
MESSAGE : DB:
DATA #1 : Hexdump, 8 bytes
0x00EE0441 : 5449 4141 4352 4551 TIAACREQ

2009-06-03-19.11.48.392000-300 I31759H235 LEVEL: Error
PID : 5660 TID : 888 PROC : odbcad32.exe
INSTANCE: DB2 NODE : 000
MESSAGE : Sqlcode
DATA #1 : String, 10 bytes
SQL -1005


We didn't find any description for SQL error code 1005 or 3000. Any help will be greatly appreciated.
Reply With Quote
  #2 (permalink)  
Old 06-04-09, 08:41
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
SQLCODE 1005 is a regular SQLCODE described in the manual:
Quote:
$ db2 "? sql1005"


SQL1005N The database alias "<name>" already exists in either the local
database directory or system database directory.
I haven't found -3000, however. It may not be a DB2 error code, depending on your description.
__________________
Knut Stolze
IBM DB2 Analytics Accelerator
IBM Germany Research & Development
Reply With Quote
  #3 (permalink)  
Old 06-04-09, 11:13
sachuu sachuu is offline
Registered User
 
Join Date: Jun 2009
Posts: 5
Any pointers

Hi,
Thanks for your reply however there is no issue with database instances or DSN already created.

Can someone throw some light on what could be the possible reason of getting this error suddenly? Thanks in advance.
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