Hi, Any one seen this type of error and i dont know how to solve this error can any one help me in this? Thanks Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP437_CI_AS" in the equal to operation.
"SQL_Latin1_General_CP437_CI_AS" is MS-DOS Latin US sort order which isn't the
same as "SQL_Latin1_General_CP1_CI_AS". your SQL is mixing collations. if you
don't want to alter your tables to make the collation match, you can simply cast
the collation using the COLLATE clause
WHERE someColumn COLLATE SQL_Latin1_General_CP1_CI_AS = someOtherColumn
where someColumn is the SQL_Latin1_General_CP437_CI_AS collation.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices