Transaction with ASP and MYSQL

Discussion in 'Databases' started by ralphk, Mar 6, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. ralphk

    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.
     
    ralphk, Mar 6, 2004
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    You can't. We do not have transactional support enabled on mysql.

    Consider using MS SQL if you need transaction.

    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">
     
    Bruce, Mar 7, 2004
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page