cannot sync offline database

Posted by Andaiye on October 29, 2009, 4:00 pm

Please log in for more thread options

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."

Posted by convoluted on October 29, 2009, 5:31 pm

Please log in for more thread options

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.

"Andaiye" wrote:

> 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."

Posted by Andaiye on November 5, 2009, 11:03 am

Please log in for more thread options

i tried that but it still made no difference.

"convoluted" wrote:

> 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.

> "Andaiye" wrote:

> > 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."

Posted by davidschultz45 on November 5, 2009, 11:21 am

Please log in for more thread options

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

"Andaiye" wrote:

> i tried that but it still made no difference.

> "convoluted" wrote:

> > 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.

> >

> > "Andaiye" wrote:

> >

> > > 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."

Posted by Maurice @ ARS on November 6, 2009, 2:20 pm

Please log in for more thread options

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 Filesmicrosfot SQLmsql.1binnSQLSVR.EXE

2) Make sure that the Open Rowset is checked in the surface area
configuration.

Then let us know the results

--
Maurice Gordon
Maurice@americanretailsupply.com
Sales/Support
1-800-426-5708 XT 1307

>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."