Resolving “UDA-SQL-0569 Unable to load the driver manager library ( db2cli.dll )” with Framework Manager 10.1

When installing Framework Manager 10.1 and attempting to use it for the first time, things went down hill nearly immediately.  I made sure to install a copy of the DB2 client on my development machine, but I still ran into issues connecting to data sources in Framework Manager.

For those who need to install a DB2 client, IBM provides those downloads here for DB2 10.1.  For other versions, you can go here.  [Added 3/19/2013]

A good explanation of what each DB2 client “package” includes and what they’re used for can be found here.

Steps that I was taking:

  • Load Framework Manager and open a project
  • Expand Data Sources
  • Right-Click Data Source and click Test
  • The following happens:

SNAGHTML194624

Text from dialog box:

QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
DW
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. ).

How I resolved this:

I simply moved C:Program FilesIBMSQLLIBBIN placed in PATH variable near the front of the list of directories. Depending on your installation directory, you may need to change the path above to fit your environment.  But this seems to have resolved my problem entirely.

  • http://www.pakzilla.com Tahir Akram

    Hi Andrew

    I don’t have installed DB2 on my client machine. I am using Framework Manager on Windows and my Cognos is on a separate Unix server. How can I fix this error?

    Can you share db2cli.dll with me. If having this file at some local directory can resolve this issue.

    Thanks.

    • Andrew Bancroft

      Hi Tahir!

      I updated this post to include links to IBM’s DB2 client download page. My recommendation would be to install a DB2 client on the machine that Framework Manger is installed on first. There may be other dependencies that Framework Manager needs.

      I also included a link to an article explaining what each DB2 client package includes and what each one is used for so you can choose the right one for your needs.

      I hope this is helpful. Definitely let me know if this fixes your issue, or if you end up resolving it some other way.