COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: spyder2000 on 29 Apr 2009 02:02:36 PM

Title: Windows Server 2003 ODBC to a source on share drive fails
Post by: spyder2000 on 29 Apr 2009 02:02:36 PM
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
Title: Re: Windows Server 2003 ODBC to a source on share drive fails
Post by: smiley on 29 Apr 2009 03:49:52 PM
Does the Cognos 8 NT service account have access to the share where the spreadsheet resides?