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.