ODBC Data Source Fails After Upgrade (Microsoft Text Driver)

[LDJB81]

Hi all

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:

QE-DEF-0285
QE-DEF-0325
RQP-DEF-0068
UDA-SQL-0031
UDA-SQL-0107

Any help would be much appreciated.

thanks
Lloyd

[LDJB81]

It turned out to be the permissions on the of the service account like you said. I forgot to change the logon of the Cognos 10 service from Local System to the designated service account.