SQL Transactions from ASP

[bgreenhouse]

Hi Folks

I've read a bit about MTS - but I'm not sure it applies to what I want to do. I simply want to be able to commit, begin and rollback SQL transactions (on an access database) from an ASP page. So I've tried what seems obvious - passing it as I would any other SQL statement...

dbObj.execute "BEGIN TRANSACTION"

and

dbObj.execute "END TRANSACTION"

but it doesn't like that, giving me

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

Any suggestions? Anything obvious?

Thanks,

Ben

 

[bgreenhouse]

For anyone searching for the answer, I've found it...Use your connection object (dbObj in this example), and use the following commands:

dbObj.BeginTrans
dbobj.RollbackTrans
dbobj.CommitTrans

It's pretty easy...

B