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
No comments:
Post a Comment