Microsoft.Jet.OLEDB.4.0 provider-'System.InvalidOperationException' occurred in system.data.dl

Is Microsoft.Jet.OLEDB.4.0 provider support transactions?

Thanks in advance.

if the answer is yes i would be glad to have a reference for a good example for using begintransaction,commit, and rollback.

Thanks

[237 byte] By [tomer_t] at [2008-1-3]

# 1

Just use the OleDbConnection class methods BeginTransaction, Commit and Rollback.

PaulPClementIV at 2007-9-25 >

# 2

Thanks for your help.

i did try the code on the following link: http://msdn2.microsoft.com/en-us/library/system.data.oledb.oledbconnection.begintransaction(VS.71).aspx
but i get the following exception : An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll
Additional information: This OleDbTransaction has completed; it is no longer usable.

this exception occure when : myTrans.Rollback();

Please help me avoid this exception.

Please advice.

tomer_t at 2007-9-25 >

# 3

Has the transaction already been committed? You can't roll it back if the Commit method has been called.

PaulPClementIV at 2007-9-25 >

.NET Development Hot Topic