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.