Error with HQ

Jun 09, 2008 1 Replies

I had my first store setup running with HQ Server with no problem. Just installed RMS in my 2nd store and synchronized with no problem. But I think when my frist store created a new customer and the 2nd store does a 401, it is getting this error with HQ Client until this line shows up:



Received 1 new global customer record(s) from HQ Error-2147217900: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "..... Error-214217900: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "..... Error91:Object variable or With block variable not set (Unhandles Error, state = '9') An error was detected, connection will be aboreted



The lines after ... got cut off by my printer.



The collation order of the SQL server at the store/s is different to the collation order of your HQ

Check the collation setting on HQ and both stores and see which one is the problem.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required