No such interface error in using Transactions - Please help. 1

[Deadline]

Hi,
I am having a ASP page that uses transaction (@TRANSACTION at the top of the page.) When I encounter the

 cn.Open myConnectionString

statement, I get an error

 No such interface is supported

. But when I remove the

@TRANSACTION

directive, it passes the

cn.Open

successfully.. But gives another error that reads something like... @TRANSACTION directive should be given... or something of this sort.

My Backend is Access2000 and I am using Interdev 6 with SP5 and I am running it on WinNT server, Win2000 as my development machine.

Can you help me fix this problem ? Very Desperate...

in advance, Thanks!

RR

 

[dilettante]

See my other answer to "Access 2000 transactions in ASP" in this forum.

Access doesn't support transactions.

Why are you trying to use transactions? This is for distributed transactions, where you update multiple databases, generally on different DB servers, and you want a failed update to one server to result in the rollback of the updates to the other server(s)/database(s).

You probably don't need @TRANSACTION at all, but are instead doing yet something else inappropriate for an application using an Access .mdb - that's why it complains when you leave @TRANSACTION out.

Hope you solve your dilemma!