IBM Support

Cannot connect to 64-bit Access database from TM1 Turbo Integrator

Technote (FAQ)


Question

Trying to connect to a 64-bit MS Access database using Turbo Integrator fails:

A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):
The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

Cause

For the 64-bit version, Microsoft does not, per default, ship any ODBC drivers to connect to the 64-bit version of the JET (MS Access) database (see http://support.microsoft.com/kb/957570)

Answer

Download the Microsoft Access databse Engine 2010 Redistributable from:

http://www.microsoft.com/en-us/download/details.aspx?id=13255 and install the 64-bit driver for the MS Access db.

2007 version: http://www.microsoft.com/en-us/download/details.aspx?id=23734

Document information

More support for: Cognos TM1
TM1 Turbo Integrator

Software version: 10.1.1

Operating system(s): Windows

Software edition: All Editions

Reference #: 1645568

Modified date: 27 September 2016