Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: terry_stjean on 04 Nov 2013 10:10:43 AM

Title: Excel 2010 driver not shown
Post by: terry_stjean on 04 Nov 2013 10:10:43 AM
I'm running Cognos Data Manager 10.2.
We have installed Excel 2010 on the same server.
When I open the OBDC Data Source Administrator from the Windows Admin tools, I can add a data source for .xlsx. The driver has a version number of 14.00.6015
When I open the ODBC Data Source Administrator from within Data Manager, I only see Excel .xls drivers. The driver has a version number of 6.01.7601

Any idea why I am seeing different drivers depending on where I open OBDC Data Source Admin?
Title: Re: Excel 2010 driver not shown
Post by: ROBER82167 on 06 Nov 2013 09:03:05 AM
Although Data Manager 10.2 supports 64-bit, the Designer UI is 32-bit so invokes the 32-bit ODBC Data Source Administrator. From Windows Admin tools you are almost certainly invoking the 64-bit ODBC Data Source Administrator.
Title: Re: Excel 2010 driver not shown
Post by: MFGF on 13 Nov 2013 06:16:05 AM
Yep - agreed. Good call! :)

MF.
Text only | Text with Images