IBM Support What's New?

IBM Cognos Insight Cannot Connect to 32-bit ODBC Driver on a 64-bit Microsoft Windows Platform

Technote (troubleshooting)


IBM Cognos Insight cannot connect to a 32-bit ODBC driver on a 64-bit Microsoft Windows platform. If the ODBC connection was defined as a System DSN, it is not visible in IBM Cognos Insight. If it was defined as a User DSN, it is visible in IBM Cognos Insight, but an error is given when trying to test the connection or query against the data source.


When testing a 32-bit User DSN ODBC connection in IBM Cognos Insight running on a 64-bit platform, the following error message is displayed:

Unable to test connection.

Cannot open data source connection.

If you try to query against the data source, the following error appears:

Cannot preview the data.

SQL statement execution failed.: DatabaseConnectionFailed


IBM Cognos Insight comes as a 32-bit install or 64-bit install (from version 10.2.1 and up).

The 64 bit version currently cannot connect to 32-bit ODBC drivers.

For the 32-bit version, by default, 32-bit System DSNs are not visible in IBM Cognos Insight running on a 64-bit platform. The TM1 portion of IBM Cognos Insight, by default, will run as a 64-bit application on a 64-bit platform. 64-bit applications cannot connect to 32-bit ODBC drivers.


64-bit versions of Microsoft Windows

Resolving the problem

There is currently no remedy for the 64-bit version of Cognos Insight other than installing and using the 32-bit version.

If you are using the 32-bit version of Cognos Insight on a 64-bit version of Microsoft Windows and are using a 32-bit version of an ODBC driver, you can configure the TM1 portion of IBM Cognos Insight to run in 32-bit mode thereby allowing you to connect to 32-bit ODBC drivers. To do this:

· Go to the IBM Cognos Insight install location (can be located by looking at the Target property in the Properties dialog of the IBM Cognos Insight shortcut located on your desktop).

· Open the configurations folder, and then open the config_10.2.xxxx.x folder.

· Open config.ini in a text editor and add the following line to the end of the file:


· Save and close the file.

You will then need to define the ODBC connection using the 32-bit version of ODBC Data Source Administrator located at %systemdrive%\Windows\SysWoW64\odbcad32.exe. Please refer to Microsoft documentation for more information on ODBC Data Source Administrator.

If you installed Cognos Insight from an IBM Cognos portal, the appropriate bit-depth client will be installed based on the bit-depth of the OS unless you have an older 32-bit Cognos Insight version already installed. In that case it will install the 32-version regardless of OS bit-depth. If you install from a portal and get the 64-bit version but require connecting to 32-bit ODBC drivers, then you will need to uninstall the 64-bit version and request the 32-bit version msi from the Cognos administrator. The msi installer files are located in <Cognos BI install location>\webcontent\rcp_installs for Cognos BI or in <TM1 install location>\webapps\pmpsvc\rcp_installs for TM1.

If you are using Microsoft Office files as a data source, you have the option of installing a 64-bit version of Microsoft Office, which was introduced in Office 2010. By doing this, there is no need to reconfigure your 32-bit version of Cognos Insight, or you can install the 64-bit version of Cognos Insight to take advantage of the extra memory space.

Document information

More support for: Cognos Insight

Software version: 10.1, 10.1.1, 10.2, 10.2.1

Operating system(s): Windows

Software edition: All Editions

Reference #: 1616205

Modified date: 2013-10-10