cannot sync offline database

i get an error when i try to do a Z report when offline the error is
"Runtime error 2147217900 (80040e14):
Cannot resolve collation conflict between 'Latin1_General_CI_AS' and
'SQL_Latin1_General_CI_AS' in the equal to opperation."
Reply to
Andaiye
The database collations need to match between the register and the database server. Change the collation on the register to match the collation on the server. You can do this in Store Operations Administrator - Database - Change Collation. I would recreate the offline database after you have changed the collation, then try synchronizing it with a Z report.
Reply to
convoluted
First thing to try is to make sure in store ops administrator that you can connect to the local offline database. Open store ops admin \ File \ Configuration \ Offline Tab \ Test Database Connection. You shoudl get a connected succesfully. If not then there is a setup problem with your offline DB.
If you connect succesfully then try the following. Turn off the Windows Firewall on the POS machine, reboot the POS, then try and run your Zreport and sync the offline database.
David
Reply to
davidschultz45
Heres what I would do,
Create a backup of your current databse take a copy to the register you are having problems with and create a new copy of the offline DB and setup the offline tab in the cofiguration pointing to the new offline DB.
Then 2 things to look for
1) Make sure whatever firewall you are using that you have added SQLSVR.EXE from c:\program Files\microsfot SQL\msql.1\binnSQLSVR.EXE
2) Make sure that the Open Rowset is checked in the surface area configuration.
Then let us know the results
Reply to
maurice
Thanks for all ur help, another work mate looked at it and got things to work, but i dont have details of what was done, thanks very much.
Reply to
Andaiye
i think i'm having the same issue when i try to sych database with offline using z or blind
Where can i find this Open Rowset setting on sql express 2008
Thanks Robert
Reply to
Robert
Another thing to check for offline DB sync failure is that port 1433 is opened in your firewall.
Marc
Reply to
Marc
i think i'm having the same issue when i try to sych database with offline using z or blind
Where can i find this Open Rowset setting on sql express 2008
Thanks Robert
Reply to
cptsoft

Site Timeline Threads

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.