Cognos Planning 10.1.1
Analyst on Microsoft Windows 7 64 bit
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.
The setup routines for the Microsoft Excel Driver (xls xlsx xlsm xlsb) ODBC driver could not be found. Please reinstall the driver.
In windows 7 the odbc icon in administrative tools are for 64 bit connections, and cognos planning use only 32 bit connections.
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.