IBM DB2 driver installed but Spotfire data connector is still disabled
Article ID: KB0082633
Updated On:
| Products | Versions |
|---|---|
| Spotfire Connector for IBM DB2 | 7.11 and lower |
Description
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.
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.
Issue/Introduction
After installing an IBM DB2 ODBC driver and then restarting the TIBCO Spotfire installed client, when trying to add data from the IBM DB2 data connector the connector still shows up greyed out and there is a message saying there is no driver installed.
Resolution
To resolve this issue you will need to change the name of the driver. This can be done by following the steps below. 
- Go to Registry Editor (type : "regedit" in Windows +RUN)
- Go to this path "[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI]"
- Within the folder ODBC Drivers, edit the folder with the IBM DB2 ODBC Driver Name to "IBM DB2 ODBC DRIVER"
- Go to this path "[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]"
- Edit the IBM DB2 ODBC Driver Name to "IBM DB2 ODBC DRIVER"
- Restart the Spotfire client.
Feedback
Yes
No
Powered by
