8 Replies Latest reply: Nov 8, 2009 12:14 AM by Don Williams RSS

DB2 Express C JDBC or ODBC connection

Chris Drake
Currently Being Moderated

I am trying to connect to DB2 for windows (db2 9.5 express connect) with either ODBC or JDBC. I am not having any success.  I have downloaded the db2jcc and db2jcc4 along with the IBM Data Server Driver (ODBC).....where do I go from here.

  • Re: DB2 Express C JDBC or ODBC connection
    Prathamesh Acharya
    Currently Being Moderated

    Hi Chris

     

    If you have installed the driver on the machine then you will be able to see the driver name listed the available driver's list.

     

    Please follow the steps as below:

    A] Create a DSN

    1. Go to Start>>Control Panel>>Administrative Tools>>Data Source(ODBC).

    2. In System DSN tab click on Add.A list of drivers will pop up

    3. The name of your driver would be probably "IBM DB2 driver for........".

    4.Enter the data source name/server/user name/password.

    5. This will create the DSN.

     

    B] Use the DSN to create report

    1. Now open crystal reports,select blank report,under Create New Connection select ODBC(RDO).

    2. Select the respective DSn which you created in step A and proceed further to create the report.

     

    Let me know if this is what you are looking at.

     

     

    Thanks

  • Re: DB2 Express C JDBC or ODBC connection
    Zilla Eh
    Currently Being Moderated

    Is your system 64 bit? if so you need to make changes to the registry. make sure you make a copy of the original exported reg files. The should be || in the text below should actually double backslashes. If I use double backslashes it changes the format of the text.

     

    1) On 64 bit machines export the following keys from the registry.

     

    HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM DB2 ODBC DRIVER

     

     

    2) Edit the exported registry files.........

     

     

    -


     

     

    Windows Registry Editor Version 5.00

     

    [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\IBM DB2 ODBC DRIVER]

    "UsageCount"=dword:00000001

    "Driver"="C:||Program Files||IBM||SQLLIB||BIN||DB2CLIO.DLL"

    "Setup"="C:||Program Files||IBM||SQLLIB||BIN||DB2ODBC64.DLL"

    "CPTimeout"="60"

     

    becomes

     

     

    Windows Registry Editor Version 5.00

     

    [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBCINST.INI\IBM DB2 ODBC DRIVER]

    "UsageCount"=dword:00000001

    "Driver"="C:||Program Files||IBM||SQLLIB||BIN||DB2CLI.DLL

    "Setup"="C:||Program Files||IBM||SQLLIB||BIN||DB2ODBC.DLL"

    "CPTimeout"="60"

       

     

     

    3) Save the .reg files above and import them into the registry.

     

    Edited by: Zilla Eh on Nov 11, 2008 12:29 AM

  • Re: DB2 Express C JDBC or ODBC connection
    Chris Drake
    Currently Being Moderated

    for the ODBC Connection, I don't see a server option...

     

    I see:

     

    DataSourceName:

    Alias (protected)

    Description:

     

    click the Add button and I see

    Description:

    UserID:

    PassWord:

     

    And and advanced settings tab for CLI Variables.

  • Re: DB2 Express C JDBC or ODBC connection
    Chris Drake
    Currently Being Moderated

    It is 32 bit

  • Re: DB2 Express C JDBC or ODBC connection
    Chris Drake
    Currently Being Moderated

    Locally on the server the test connection works.....for ODBC.

    but the instance of the ODBC driver actually living on the server was installed with the Database, and has DB2COPY2 in the ODBC driver name....

     

    From my machine, there is no where to enter a server name manually as mentioned before.....

  • Re: DB2 Express C JDBC or ODBC connection
    Chris Drake
    Currently Being Moderated

    FYI....

    I was finally able to get the JDBC connection to work,but would like to have the ODBC working as well.

  • Re: DB2 Express C JDBC or ODBC connection
    Don Williams
    Currently Being Moderated

    Please re-post if this is still an issue to the Data Connectivity - Crystal Reports Forum or purchase a case and have a dedicated support engineer work with you directly

Actions