Using transaction scope with access database

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
 
P

Patrick Steele

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.

Do you have a question about this behavior? If so, what is it?
 
M

Mary Chipman [MSFT]

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top