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

Technote (troubleshooting)


Problem(Abstract)

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.

Symptom

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

Cause

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.


Environment

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:

DTM1_DISABLE_64BIT=true

· 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.


Rate this page:

(0 users)Average rating

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

Translate my page

Machine Translation

Content navigation