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.