Topic
4 replies Latest Post - ‏2013-08-16T12:40:54Z by AnantPandey
SystemAdmin
SystemAdmin
214 Posts
ACCEPTED ANSWER

Pinned topic UDA-SQL-0569 Unable to load the driver manager library ( db2cli.dll )

‏2009-10-30T13:51:35Z |
When creating a DB2 data source, has anyone encountered the error below and how did you resolve?

Thanks.
org.xml.sax.SAXException: UDA-SQL-0569 Unable to load the driver manager library ( db2cli.dll ). UDA-SQL-0571 The operating system returned an error message ( The specified module could not be found. ).
Updated on 2012-06-16T06:47:48Z at 2012-06-16T06:47:48Z by XJKW_Robert_Gauf
  • krecoskie
    krecoskie
    11 Posts
    ACCEPTED ANSWER

    Re: UDA-SQL-0569 Unable to load the driver manager library ( db2cli.dll )

    ‏2009-11-02T16:04:41Z  in response to SystemAdmin
    Are you able to connect to the data source using Framework Manager or with the Add Data source features in Cognos Administration (accessible from the Cognos Connection portal)?

    From the error message, it appears as if the file db2cli.dll is not in the path, or that the DB2 client was installed and the system was not re-booted. If connecting using Framework Manager works but adding the data source using Cognos Express Manager does not then a reboot is required for the system account PATH to be updated.

    Otherwise, do you know if cygwin is installed on the server? Cygwin interferes with the db2 client, and the workaround is to remove the cygwin\bin from the path.
  • rramakanth
    rramakanth
    1 Post
    ACCEPTED ANSWER

    Re: UDA-SQL-0569 Unable to load the driver manager library ( db2cli.dll )

    ‏2011-04-27T18:20:06Z  in response to SystemAdmin
    Hi,
    Had faced the same issue, I was able to resolve it by copying the db2cli.dll into the bin folder of cognos installation directory and restarting the application server.

    There are couple of solutions provided in the following link:
    https://www-304.ibm.com/support/docview.wss?uid=swg21450905

    Hope it helps.

    Regards,
    Ravi.
    • AnantPandey
      AnantPandey
      1 Post
      ACCEPTED ANSWER

      Re: UDA-SQL-0569 Unable to load the driver manager library ( db2cli.dll )

      ‏2013-08-16T12:40:54Z  in response to rramakanth

      thanks a lot ramakanth, it worked for me :)

  • XJKW_Robert_Gauf
    XJKW_Robert_Gauf
    1 Post
    ACCEPTED ANSWER

    Re: UDA-SQL-0569 Unable to load the driver manager library ( db2cli.dll )

    ‏2012-06-16T06:47:48Z  in response to SystemAdmin
    I was getting this same problem on a Windows7 client workstation trying to connect to a DB2 datasource in Framework Manager. Threw the message as it tried to connect to show schemas in source database

    • I can "test" the connection successfully in both FM (on client) and in Cognos Admin (running on separate Windows7 server machine)
    • Installed 32 bit DB2 Client Tool on both server machine and client machine. "Cataloged" TCPIP connection and database using DB2 CLP just to get to the point where the test would work.

    • I do not have Cygwin installed (as noted above), but there were a number of other development tools in the environment (Oracle SQL tools, MS Sql Server, other MS bits).
    Not sure which one was conflicting with the DLL:
    PATH=C:\app\oracle\product\11.2.0\client_1\bin;C:\Tools\IBM_SQLLIB\BIN;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft Application Virtualization Client;C:\Program Files (x86)\1E\NomadBranch\;C:\Java\j2se-6_JDK-64\bin;C:\Program Files(x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files(x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files\TortoiseSVN\bin;C:\Program Files (x86)\SSH Secure Shell

    • Copying db2cli.dll to <Cognos install>\bin and then re-booting client machine did nothing. Still threw DLL error.
    • Changed System Path, to place <DB2 Client Install>\bin high in path on client machine, thus:
    PATH=C:\app\oracle\product\11.2.0\client_1\bin;C:\Tools\IBM_SQLLIB\BIN;C:\Windows\system32;...
    • Then re-booted client machine too.

    Finally SUCCESS!