Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    5

    Question Unanswered: 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.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    SQLCODE 1005 is a regular SQLCODE described in the manual:
    $ 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

  3. #3
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •