I have created a report in Crystal Reports 10 that is connect to an SQL Server 2005 database. I have used OLE DB (ADO).

The problem is that i want now to connect this report to another database instead, using "Set Datasource Location" and is giving me the error:
"Failed to open a rowset.
Details:ADO Error Code: 0x90040e14
Source:Microsoft OLE DB Provider for SQL Server
Description: Cannot resolve te collation conflict between 'Latin1_General_CI_AS' and 'SQL_Latin1_General_CP1_CI_AS' in the equal to operation.
SQL State:42000
Native Error:468"

I went verify the two databases and i saw (properties of the database in sql 2005) that the two had diferent Collations.

One had "Latin1_General_CI_AS" and the other had "SQL_Latin1_General_CP1_CI_AS"

I have changed the first one to "SQL_Latin1_General_CP1_CI_AS" but when i set the new database and i do a refresh the same error appears.

I do not know what i am doing wrong. Can you help me?

Thank you in advance