IBM DB2 driver installed but Spotfire data connector is still disabled

IBM DB2 driver installed but Spotfire data connector is still disabled

The TIBCO Spotfire data connector for IBM DB2 looks for an installed driver named IBM DB2 ODBC DRIVER on the system. Normally when you install the driver you'll get two entries, one being the previous entry called IBM DB2 ODBC DRIVER and one with a suffix like -IBMDBCL1:



But we've seen cases where the installation has only produced one entry, the one with the name containing the suffix. Then the TIBCO Spotfire data connector for IBM DB2 will not find the driver it is looking for, as it looks for the specific name IBM DB2 ODBC DRIVER, and the data connector will remain disabled. To resolve this issue you will need to change the name of the driver. This can be done by following the steps below.

1. Go to Registry Editor (type : "regedit" in Windows +RUN)
2. Go to this path "[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI]"
3. Within the folder ODBC Drivers, edit the folder with the IBM DB2 ODBC Driver Name to "IBM DB2 ODBC DRIVER"
4. Go to this path "[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]"
5. Edit the IBM DB2 ODBC Driver Name to "IBM DB2 ODBC DRIVER"
6. Restart the Spotfire client.