Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2012
    Posts
    29

    Unanswered: ODBC connection to db2aese 64 bit

    Hi all,
    I have an ODBC connection string like this:

    "Driver={IBM DB2 ODBC DRIVER - DB2COPY1};Hostname=localhost;Database=MYDB;UID=db2 admin;password=db2admin;CurrentSchema=MYSCHEMA;Cur rentFunctionPath=MYSCHEMA"

    I'm using ODBC 3.0, and I first successfully connect to a DB with this characteristics:

    DB2 installed: 32 bit
    Product name from db2licm -l : "DB2 Advanced Enterprise Server Edition"
    Product id from db2licm -l : "db2aese"
    Version from db2licm -l : "9.7"
    OS : Win XP Professional SP 3 or Win7 Professional SP1


    When I try (always connecting locally) with a db with this characteristics:
    DB2 installed: 64 bit
    Product name from db2licm -l : "DB2 Enterprise Server Edition"
    Product id from db2licm -l : "db2ese"
    Version from db2licm -l : "9.7"
    OS : Win7 Ultimate

    I cannot connect to the database, and get the error:
    Database Error: [IBM][CLI Driver] SQL0902C A system error (reason code = ) occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005 (58005:4294966394)

    If I create an ODBC data source and try connecting with it, passing the correct user and password, I get the error (while in the first environment also this connection works):
    Database Error: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
    (08001:4294937214)

    Please could anyone help me understand what's the problem?

    Thanks

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    always try a native connect without odbc .. and see if uid/pw is valid
    check diaglog for additional info
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jan 2012
    Posts
    29
    I've never used a native connection..
    Could you please suggest the quickest way to try it?

    Thanks

  4. #4
    Join Date
    Jan 2012
    Posts
    29
    However, if it's just to be sure of userid/pwd... I tested it with the ODBC Data source and the connection there was successful..

    Are there any known problems when connecting a 32 bit ODBC application with a 64 bit DB2 server?

Posting Permissions

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