PDA

View Full Version : Transaction with ASP and MYSQL

ralphk
03-06-2004, 10:26 AM
How do I implement transactions with ASP and MySQL?...

I've tried:

theConn.beginTrans
theConn.RollbackTrans
theConn.CommitTrans

But I get the following error:

ADODB.Connection error '800a0cb3'

Object or provider is not capable of performing requested operation.
bruce
03-07-2004, 04:44 AM
You can't. We do not have transactional support enabled on mysql.

Consider using MS SQL if you need transaction.

[b]quote:Originally posted by ralphk


How do I implement transactions with ASP and MySQL?...

I've tried:

theConn.beginTrans
theConn.RollbackTrans
theConn.CommitTrans

But I get the following error:

ADODB.Connection error '800a0cb3'

Object or provider is not capable of performing requested operation.


</blockquote id="quote"></font id="quote">