Script Error: Cannot resolve the collation conflict

Tue, 08 Feb 2011 18:44:28 GMT

I'm getting the following script error: "ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation."

The bit of script itself is fairly straight forward:


SQL SELECT DISTINCT *
FROM Table2
 WHERE EXISTS
 (SELECT * FROM Table1 WHERE Table2.Field1 = Table1.Field1
 AND Table2.Field2 = Table1.Field2)

I'm stumped. Has anyone run into this and have any recommendations?

Script Error: Cannot resolve the collation conflict

prieper — Tue, 08 Feb 2011 21:35:20 GMT

Looks as if you have mixed the SQL-part with the QV-script-part.

You may have the SQL-syntax preceded with the QV-owned LOAD, like:

LOAD * WHERE EXISTS(YourField); SQL SELECT .... [here your SQL-statement];

Though the SQL will be performed and then further restricted/manipulated as per the preceding load.

HTH
Peter

topic Script Error: Cannot resolve the collation conflict in QlikView

Script Error: Cannot resolve the collation conflict

Script Error: Cannot resolve the collation conflict