SQL CE - Push when server is down?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
We have a ppc app that uses sql ce , we use push and pull with tracking to
send and receive data from the server.

the problem is that if the connection is lost to the server while pushing ,
all data is lost ( ? ) on both client and server.

is there any way around this problem?

//Roger
 
Looks like you are using Nonbatch Transactions. Take a look into the error
table. Here is the description from SQL CE 2.0 Books Online:

"During nonbatch transactions (BATCHINGOFF option), conflicts are detected
at the row level. The conflicting row is returned to the application and
stored in a specified error table. For example, if the application attempts
to push a row to SQL Server that is not valid, that row is returned to the
application and stored in the error table along with an error message
indicating the conflict.

When a conflicting row is returned to the error table, that row is removed
from the original Windows CE-based database. You must design the
application to allow the user to correct the conflicting data and merge the
conflicting data back into the original Windows CE-based database."
-------------------

You may use "Batch Transactions" where the original Windows CE-based
database is kept intact.

You can access SQL Server CE Knowledge Base articles at:

http://support.microsoft.com/default.aspx?scid=fh;EN-US;KBHOWTO
( select ' SQL Server CE ' as the product )

Thank you!
Syed N. Yousuf
Microsoft Developer Support Professional

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top