Transactions with MSAccess mdb File

If you use Distributed Transactions within your Application and an Access .mdb a DataContainer then you maybe did get this:

System.InvalidOperationException: The ITransactionLocal interface is not supported by the 'Microsoft.Jet.OLEDB.4.0' provider.  Local transactions are unavailable with the current provider.

SOLUTION:
Don't let Access participate in this Distributed Transaction
System.Transactions.TransactionScopeOption.Suppress


Msdn Link: Supporting Transactions in OLE DB

Latest Posts

Popular Posts