COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: jonky on 13 Nov 2012 09:06:26 AM

Title: Excel as ODBC Data Source - Problem to access
Post by: jonky on 13 Nov 2012 09:06:26 AM
Hi all,

I want to add Excel Files as Data Sources. I followed the standard procedure (like here (http://www.cognoise.com/community/index.php?topic=6552.0)).

My first file is integrated successfully and I was trying to do the same with another. I am now stuck at testing the connection string in the Create New Data Source-process, which always fails.

Interestingly, it also fails when I point to an exact copy of the first file, so the format of the xls is definitely not the problem. I am suspecting it may have something to do with the file being locked.
The host on which I am working does not have Excel installed though, so the file only gets copied on the hard drive.

When I try to add the Datasource without the wizard directly in Framework manager, I get the following error:
"QE-DEF-0288 Unable to find the data source 'Utilization' in the content store.". Is this the root of the problem? How can I solve it?

Any tips on this?

Thanks,
jonky