Mobility Site - View Single Post

CDurbin · 03-02-06, 10:06 PM

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.

03-02-06, 10:06 PM	#2 (permalink)
CDurbin Aximsite Prospect Join Date: Feb 2006 Posts: 10 Thanked 0 Times in 0 Posts	Got a reply to try 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.