Welcome to the new CogKnowHow.com!


If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

When you start ODBC Data source administrator to add ODBC connections to xls files you get a error


#1
Product:Cognos Planning 10.1.1Analyst on Microsoft Windows 7 64 bit
Symptom:When you start ODBC Data source administrator to add ODBC connections to xls files you get a error on your brand new Windows 7 computer.
You need to add ODBC connection to be able to import xls files into Cognos Analyst for Planning. Inside Analyst how you selected New D-Link and then click on source, and selected ODBC (SQL) database. But then there are no connections to select, you have to create the connections in the ODBC tool.
Problem:The setup routines for the Microsoft Excel Driver (xls xlsx xlsm xlsb) ODBC driver could not be found. Please reinstall the driver.
Cause:In windows 7 the odbc icon in administrative tools are for 64 bit connections, and cognos planning use only 32 bit connections.
Solution:Create a shortcut to the file c:\windows\syswow64\odbcad32.exe
Use this icon to edit the ODBC connection for Excel to be used in Cognos Planning.

www.cogknowhow.com