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.