Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
3 replies Latest Post - ‏2012-07-11T06:46:56Z by SystemAdmin
RituHooda
RituHooda
1 Post
ACCEPTED ANSWER

Pinned topic Need Driver for IBM DB2 Express-C 9.x

‏2012-06-26T22:10:39Z |
Hi,
I only need the drivers for IBM DB2 Express-C 9.x(for 64-bit version), and not the full client.
Please advise the right link, or the right file.
I have the clkient installed on one of our system.
I appreciate if you can provide the right driver file name or a link to the right driver.
Updated on 2012-07-11T06:46:56Z at 2012-07-11T06:46:56Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    5837 Posts
    ACCEPTED ANSWER

    Re: Need Driver for IBM DB2 Express-C 9.x

    ‏2012-07-05T13:47:31Z  in response to RituHooda
    Hello,

    Point your browser to :
    http://www-01.ibm.com/support/docview.wss?uid=swg24032754

    Choose your platform (e.g. "Linux 64-bit, x86-64 on AMD64 and Intel EM64T")

    Depending on your application(s), choose one of the following :
    IBM Data Server Driver package
    IBM Data Server Driver for ODBC and CLI
    IBM Data Server Driver for JDBC ans SQLJ

    Hope this helps...
    Regards

    Yves-Antoine Emmanuelli
    • RItuDevHooda
      RItuDevHooda
      1 Post
      ACCEPTED ANSWER

      Re: Need Driver for IBM DB2 Express-C 9.x

      ‏2012-07-10T18:52:59Z  in response to SystemAdmin
      Thanks much . I am able to install the drivers using IBM Data Server Driver package
      NOw I want to create an ODBC connection with this driver.
      When I try to connect, it says that the database alias is not found in db2dsdriver.cfg configuration file.
      Do I need to make changes to this Configuration file to use this ODBC connection to use it in my SSIS package in Visual Studio.

      Thanks
      • SystemAdmin
        SystemAdmin
        5837 Posts
        ACCEPTED ANSWER

        Re: Need Driver for IBM DB2 Express-C 9.x

        ‏2012-07-11T06:46:56Z  in response to RItuDevHooda
        Hello,

        On Linux, db2dsdriver.cfg is taken into account and the configuration is fairly straightforward.

        But I encountered the same problems as you on Windows XP a few years ago (I now only use Linux).

        I vaguely remember that on Windows XP the db2dsdriver.cfg definitions were ignored and that one had to configure the host, port and database within MS ODBC driver manager through some "advanced" (!) keywords.

        It might be a different matter with more recent versions of Windows... I am sure there are plenty of windows gurus out here who will come up with more specific instructions, if you tell them about your exact Windows platform.

        Regards
        Yves-Antoine Emmanuelli