Using transaction scope with access database

  • Thread starter Thread starter Rash VV
  • Start date Start date
R

Rash VV

Hi,

I am working on two databases one is in SQL server 2000 and one is in MS
access. My application is required to read data from the access file and
update the SQL database.
I want the complete operation to be done in a single transaction. For
that I have used TransactionScope class provided by .net 2.0.
The Application results in to the exception
"The ITransactionLocal interface is not supported by the
'Microsoft.Jet.OLEDB.4.0' provider".
It works fine if I remove the transaction.

my code is like :
using (TransactionScope scope = new TransactionScope())
{
// database operations here
scope.Complete();
}


Thanks in advance
 
I want the complete operation to be done in a single transaction. For
that I have used TransactionScope class provided by .net 2.0.
The Application results in to the exception
"The ITransactionLocal interface is not supported by the
'Microsoft.Jet.OLEDB.4.0' provider".
It works fine if I remove the transaction.
Click to expand...

Do you have a question about this behavior? If so, what is it?
 
The error message is correct -- you can't use TransactionScope with
Jet. If you need distributed transactions you should consider moving
your data to SQL Express. You can still use Access as a front-end to
the Express tables.

--Mary
 
Back
Top