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 datasource (ODBC)

Started by churchy, 09 Apr 2008 06:15:58 AM

Previous topic - Next topic

churchy

Hi,

I am trying to add an excel file as a datasource to a FM model. I created the excel driver in control "panel/Administrative tools/Data sources" but when i create and test the ODBC datasource on cognos conection i get  "QE-DEF-0285 QE-DEF-0285 The logon failed." error.
Cognos server and excel file are both installed in my local machine, so when i create the excel driver i input the local path of the file "c:\documents and setting\......\file.xls", is that correct? or may i have to set the path in other format?

Another issue is that when i create the datasource on cognos connection, i dont know what to set in "ODBC connect string" property, i only set " ODBC data source" with the DNS.

Should i have to install Composite information server  to create excel datasources?

Thanks in advance.

ducthcogtechie

Are you running FM directly on the server?
If not, can the C8 dispatcher find c:\documents and setting\......\file.xls?

churchy

FM is installed at the same computer (localhost), but at this momment i havent used it to try to access the xml, i am creating the data source directly on cognos conection.

I have probed creating an ODBC and Composite ODBC, and both raise the same error:

QE-DEF-0285 The logon failed.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
    testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" database.
UDA-SQL-0532 Data Source is not accessible: "pruebaEXCEL".
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
RSV-SRV-0042


Do i have to add the source i created in Windows control panel to Cognos.ini file??

Thanks dutchcogtechie

ducthcogtechie

Have you tried using the hostname of your computer instead of "localhost"?
(will also require replacing the localhost entry in cognos configuration/environment)

churchy

hi dutchcogtechie,
where i have to set the name of my machine? when i create the odbc connection i set "select worksheet" on control panel, but there i can only select the path of the excel using a browser, i cant set free text..

thanks

Ty Clabbers

Don't know if it is the solution but you can use the unc specification in the name field.

Just to be double sure, you are running framework on the same server where cognos connection is running? Your cognos connection is running on a single server? I am asking this because i encoutered an error in the past that looked like this on. I "forgot" to create the odbc connection on the server where cognos connection was running.