Db2

 View Only

  • 1.  Trouble with 64bit ODBC connection in DB2 11.5

    Posted Mon May 11, 2020 11:02 AM
    Dear community,

    I installed Db2 community edition on a Windows 10 operating system and am experiencing problems with its installed 64bit ODBC driver.

    In the Windows registry the driver entries appear correct
    Key: Driver                    Value: C:\PROGRA~1\IBM\SQLLIB\ BIN\DB2CLIO.DLL
    Key: Setup                    Value: C:\PROGRA~1\IBM\SQLLIB\ BIN\DB2ODBC64.DLL

    I registered a Db2 database as ODBC 64bit data source in Windows.

    When I tested the data source with MS EXCEL, I received the following error message:

    Details: "ODBC: ERROR [IM003] Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (IBM DB2 ODBC DRIVER - DB2COPY1, C:\PROGRA~1\IBM\SQLLIB\BIN\DB2CLIO.DLL)."

    The same happened when using the data source in my 64bit R application.

    As R comes with both, a 32bit and a 64bit installation, I also tried to connect to Db2 from the 32bit R console.
    Here, the connection to the alleged 64bit data source worked perfectly well.

    However, working in a 32bit R console is not a real option for me.
     
    Has someone encountered the same or a similar effect?

    I'm grateful for any hint!!

    Thank you very much

    ------------------------------
    Uli Scharffenberger
    Information Architect
    IBM Germany
    ------------------------------

    #Db2


  • 2.  RE: Trouble with 64bit ODBC connection in DB2 11.5

    IBM Champion
    Posted Tue May 12, 2020 02:05 AM
    Hi Uli,

    have you tried to register not with the 64-bit ODBC driver, but with the 32-bit instead?
    Use the 32-bit ODBC-Config Tool from C:\Windows\SysWOW64\odbcad32.exe

    I don't know, how messed up the ODBC configuration under Windows is and how messy it is for a developer to check for the right driver, but still in the 64.bit days, I experience a lot, that using 32-bit ODBC drivers is the way it usually works.

    Typically 64-bit Programs can also use the 32-bit driver, but not the other way round.

    Kind regards

    ------------------------------
    Roland Schock
    Distinguished Engineer
    ARS Computer und Consulting GmbH
    Muenchen
    ------------------------------

    Original Message


  • 3.  RE: Trouble with 64bit ODBC connection in DB2 11.5

    Posted Tue May 12, 2020 08:53 AM
    Edited by System Fri January 20, 2023 04:36 PM
    This is a known issue, I had opened up a support case on this a while back, and was told it will be fixed in the next Fixpack. The APAR number is IT29942

    It is this same as this issue from 11.1: https://www.ibm.com/support/pages/apar/IT21578

    The only fix for now (until they come out with FP1, which should be soon), is to downgrade your client install to 11.1.

    ------------------------------
    Bryan Hamby
    ------------------------------

    Original Message


  • 4.  RE: Trouble with 64bit ODBC connection in DB2 11.5

    Posted Thu May 14, 2020 01:49 AM
    Dear community,

    Yes. Downgrading Db2 to 11.1 solved my problem. Now the ODBC connection between R and Db2 works perfectly well. Both for 64bit and for 32bit.

    Thank you very much for your help.

    ------------------------------
    Uli Scharffenberger
    Information Architect
    IBM Germany
    ------------------------------

    Original Message