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

Windows Server 2003 ODBC to a source on share drive fails

Started by spyder2000, 29 Apr 2009 02:02:36 PM

Previous topic - Next topic

spyder2000

I am trying to use an ODBC connection to an Excel spreadsheet that must be accessed from a share drive.  In this configuration, it fails.

1 - On the server, the Microsoft Excel driver is used and configured to point to the spreadsheet located on the share drive.  This is the same server on which C8 is hosted.

2 - In Cognos Connection Administration, creating this data source fails at the test phase for the server on which the DSN is declared and on which C8 is hosted.

3 - Using the same configuration and test steps, moving the spreadsheet to a physical drive on the host resolves the issue.  However I cannot use this configuration as many C8 servers must access the same source (obviously using their own DSN's).

Thanks! Pointers will be appreciated.
Mark

smiley

Does the Cognos 8 NT service account have access to the share where the spreadsheet resides?