I just installed Crystal Reports 2008.
I am trying to retrieve
data from a SQL server database. I have many tables (customer, client, address,
order, product...) and I can link and successfully retrieve data from everything
except the customer table. When I display data solely from the customer table, I
have no error, but when I try to display data from customer table and address
table, I get the following error:
Failed to retrieve data from database ADO
error code: 0x Source Microsoft OLE DB Provider for SQL server Description
Cannot resolve collation conflict between "SQL_Latin1_General_CPI__CS_AS" and
"SQL_Latin1_General_CPI_CI_AS" in the equal to operation
SQL state: 42000
The
entire database had collation of CPI_CS when we got the error, and we changed
the collation of the entire database to CPI_CI to fix this error, and it still
gives the same error. When looking at the properties of the individual tables
they all have the same collation.
Just as an aside, I upgraded yesterday from CR
version 8.5 and when trying to view the database with that version, I get the
error: No rowset was returned for this table query or procedure. Error detected
by database DLL
Hope someone can help.
|