Error with HQ

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.

Reply to
Gary
Loading thread data ...

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.

Reply to
Michael

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.