Showing posts with label Error. Show all posts
Showing posts with label Error. Show all posts

Tuesday, July 3, 2012

Collation Conflict Error

We got the following error at one of our clients:

Report:
Status: Execution failed
Error: SQL Generation CompleteQueryEngine encountered error: Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42000:468: on SQLHANDLE]
.....
Cannot resolve the collation conflict between "SQL_Latin_General_CP1_CI_AS" and "Latin1_General_CI_AS"

This error occurred on one of our reports after we switched our DW database to a different server.
We are running on MSSQL 2008 R2.