If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Excel as ODBC Data Source - Problem to access

Started by jonky, 13 Nov 2012 09:06:26 AM

Previous topic - Next topic

jonky

Hi all,

I want to add Excel Files as Data Sources. I followed the standard procedure (like here).

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