Summary
Test Connection to ILMT failed with error "'IBMDADB2' provider is not registered"
Symptoms
IBM Data Server Driver Package (IBMDBCL1) 64-bit has been installed and ILMT database is cataloged.
However, Test Connection to ILMT failed with error "'IBMDADB2' provider is not registered".
IBM Data Server Driver Package version is 9.7.
Connection String is like the following:
Provider=IBMDADB2; Password=password; Persist Security Info=True; User ID=db2admin; Data Source=TLMA; Location=servername:50000; Extended Properties=""
Cause
This is a known bug of IBM Data Server Driver Package v9.7.
Please refer
IC86849: DEFAULT IBMDADB2 PROVIDER NOT REGISTERED WHEN INSTALLING IBM DATA SERVER DRIVER OR SWITCHING DEFAULT COPY TO THE DS DRIVER.
Resolution
IBM had released a 64-bit DB2 9.7 FixPack 8, it included the fix of this issue.
Workaround
Use the provider qualified with the copy name such as 'IBMDADB2.IBMDBCL1'.
To confirming the copy name, please check the registry key under "HKEY_LOCAL_MACHINE\SOFTWARE\Classes\". If "HKEY_LOCAL_MACHINE\SOFTWARE\Classes\IBMDADB2.IBMDBCL1" is existing, the copy name is 'IBMDADB2.IBMDBCL1'.
Additional Information
IC86849: DEFAULT IBMDADB2 PROVIDER NOT REGISTERED WHEN INSTALLING IBM DATA SERVER DRIVER OR SWITCHING DEFAULT COPY TO THE DS DRIVERRelated KB Articles
000016514 ILMT inventory adapter connection failed with unspecified error