This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
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
Just use the OleDbConnection class methods BeginTransaction, Commit and Rollback.http://msdn2.microsoft.com/en-us/library/system.data.oledb.oledbconnection.begintransaction(VS.71).aspx
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.dllAdditional information: This OleDbTransaction has completed; it is no longer usable.
this exception occure when : myTrans.Rollback();
Please help me avoid this exception.
Please advice.