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
Does the Cognos 8 NT service account have access to the share where the spreadsheet resides?