CDurbin

I am using Dell Axim X-50's and X-51's with SD Cards inserted in them. The Cards contain my programs, text files, and my database(.sdf). I am working with vb.net8.0 CF2.0 using VS2005. I have several progams that look and decide if I have a SD Card or not, and write to the appropriate location(I can copy the programs and database to the device and run that way also)

I just did the following test:

Keyed an order and saved it.

Removed the card and placed into a similar device

Result: 3 out of 4 times, the order was not on the card, and no files were updated. The 4th time eveything was updated fine.

It appears that my database changes are being cached.

Anyone know how I can force a write at the critical stages to the SD Card?

CDurbin

Got this from MS - Ilya Tumanov . I will try it in the AM:

OK, so that's SQL Mobile database/NETCF V2.

I would suggest following:

1. Use transactions, sample is here:

http://msdn.microsoft.com/library/de...ctiontopic.asp

2. Try closing connection as soon as you're done updating the database.

3. Both 1 and 2.

I believe transaction alone should be enough and you will be notified of transaction failure even if card was removed during update.







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