I have just upgraded a client from 8.4 to 10.1.1. All has gone fine apart from a data source connection to an ODBC connection has failed. Both Cognos 8 and Cognos 10 are running on the same server and running fine in parallel, but the data source connection on Cognos 8 returns a success. They are running a windows server 2003 environment and the ODBC connection uses a microsoft text driver to connect to a folder on another server with no authentication.
Now its starts getting weird because if I import this data source connection in to Framework Manager (cognos 10), I can see all the files in the folder, I can retrieve data from these tables and data source connection tests fine. However, if I publish the package and try pull data back from one of the query subjects in report studio, then I get same error as when I test the data source connection.
The errors I have are:
Any help would be much appreciated.