Data gone missing on sync

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Vili <virallinen@xxxxxxxxx>
Date: Fri, 22 May 2009 06:30:24 -0700 (PDT)

Hi all

I have a small mobile windows app made with C# running on Windows
Mobile 5.0 Pocket PC and syncing with sql 2005 server.

Problem I am having is following:

After I start the app, edit the setting for the app (db location, pwd/
usr etc) and sync the db with the server I get two rows of data. I
edit one and save to the db on the device. After that if the battery
goes dead the data is still there. When I start the device again I
have to edit settings again and then I have to sync the device. After
this sync the two rows are back to their original form.

Now the question is: Is this a design flaw and something that I could
change by rewriting the code (tried to look where to change but could
not find) or is it a problem with the synchronization process? Because
the mobile database file does not disappear and keeps the records
untill the second sync.

Hopefully I was clear enough.

Thanks,
Tuomo
.

Follow-Ups:
- Re: Data gone missing on sync
  - From: Paul G. Tobey [eMVP]

Prev by Date: SQL CE 3.5 database on CD
Next by Date: problem to install sqlce 3.5 sp1 on win mobile 6.1
Previous by thread: SQL CE 3.5 database on CD
Next by thread: Re: Data gone missing on sync
Index(es):
- Date
- Thread

Relevant Pages

Re: Wireless Sync Issue
... Lots of Windows Mobile 2003 devices work without any problems with the same ... sometimes making changes in a host file on the server. ... Using an O2 ATOM and unable to sync via GPRS after a USB sync unless I stop ... and the server is accessible from the Internet via ...
(microsoft.public.pocketpc.activesync)
Re: Trouble syncing Windows Mobile 6 and SBS Exchange
... the Exchange sync settings are only applicable ... I guess once it's done the first sync I'll install the cert manually and aim ... Also - under Exchange Server Settings, under the server name field it says ... I just bought a HTC S710 vox (Windows Mobile 6 Smartphone) and plan to set ...
(microsoft.public.windows.server.sbs)
Re: Trouble syncing Windows Mobile 6 and SBS Exchange
... I have 6 mobile 6 phones to get working tomorrow for a customer. ... Confusingly, the Exchange sync settings are only applicable to wireless syncing, which is step 2. ... I found where the Exchange settings are checked them and when it didn't work I removed them at which point it started syncing. ... Also - under Exchange Server Settings, under the server name field it says that this should be the same as OWA address? ...
(microsoft.public.windows.server.sbs)
Re: Trouble syncing Windows Mobile 6 and SBS Exchange
... the Exchange sync settings are only applicable ... I guess once it's done the first sync I'll install the cert manually and aim ... Also - under Exchange Server Settings, under the server name field it says ... I just bought a HTC S710 vox (Windows Mobile 6 Smartphone) and plan to set ...
(microsoft.public.windows.server.sbs)
Re: Override use of PCs IP stack/DNS when connected via ActiveSyn
... The name I'm trying to resolve is XYZ. ... From then on the app uses XYZ ... the server without any mods on the mobile or the PC. ...
(microsoft.public.pocketpc.activesync)