SQL 2K - SQL CE Replication

[Davenz]

Hi

I've developed an application that uses SQL CE on a mobile device and synchronises back to SQL Server 2000 database.

I seem to be experiencing intermittant data loss where information saved on the SQL CE database is lost during sycnronisation. It's like the database has downloaded changes from the server, but is not uploading them.

I can't see anything obvious in terms or errors/logs??

Any ideas?

Many thanks in advance,

David

 

[Davenz]

I've done some more investigation, and it seems that if an update is made to field (that happens to be DATETIME) on the server side AFTER a change to different fields on the same table on the PDA but before is has syncronised then the updates that have been made on the PDA are discarded. - does that make sense?

It seems to be this one DATETIME field, If I prevent this field from being updated at the server side, then all is OK.