Offline DB error. Collation conflict when trying to sync

(0) Share

Report

Posted on by egger29

395

Good morning. 
I am using RMS 2.0 with SQL 2005 backend.
I have set up an offline db, and when I go to sync it for the very first 
time, it comes up with this message.
'cannot resolve the collation conflict between "Latin 1_General_CI_AS" and 
"SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

I am assuming the collation between the 2 DB's aren't the same.
how can I fix this ?  
Thank you.

*This post is locked for comments