1. Home
  2. Point-Of-Sale Software
  3. HQ and Store Collation - HQ Client complains

HQ and Store Collation - HQ Client complains

Hi there, we have a serious issue here. I upgraded several shops accross europe to V1.3.1006 and SQL Server 2005. I used the 1.3 refresh for that. In germany and the netherlands everything went fine and we can use the HQ Client to send the data to the german and dutch HQ databases. In France, Switzerland and Spain however the HQClient stops in the middle of the WS 250 saying that the database collations are different although i checked both collations and they are the same (as far as Store Op Admin, HQ Admin and Server Management Studio says). Any ideas?

Chris

Reply to
Christian Olsen
Loading thread data ...

You may have the correct collation for the whole database, but every field of every table has its collation. Anyway check every field in the item table and sure that it has the correct collation.

Sp_help ITEM

"Christian Olsen" wrote in message news: snipped-for-privacy@microsoft.com...

Reply to
Mahmoud Amin

Sorry,

when you run Sp_help ITEM, you will have null values in the collation field which means "default database collation"

thanks,

Reply to
Mahmoud Amin

Hello Mahmoud,

thanks for your quick reply. Do you mean I have to check every field of the storedatabase against the serverdatabase? If so: is there a table where the field-related collations are stored so that I can compare them usin SQL?

Chris

"Mahmoud Am> Sorry,

Reply to
Christian Olsen

Hi Christian, As you mentioned that the connection is working fine in some sites, so you have to check sites (store database) that is not connected, and the connection is stopped in WS250 "Inventory Items" that is related to Item table, so (query is: sp_help item) will query the item table and give you the information about every field in that table. note that null values refering to "database default collation"

hope this helpful..

"Christian Olsen" wrote in message news: snipped-for-privacy@microsoft.com...

Reply to
Mahmoud Amin

Sorry, that was my mistake. The error occurs in the WS401 It says the collation error occured during:

SELECT #UpdateWorksheet_DataUpload_LocalCustomers.* FRUM #Upd

noth> Hi Christian,

Reply to
Christian Olsen

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.