ADO: Can I insert a stored procedure in a transaction

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Filips Benoit
    #1

    ADO: Can I insert a stored procedure in a transaction

    Hi,

    Can I mix ADO-code (insert, update recordsets) and stored procedures in a
    transaction?

    Filip


    Tags: None
    • Steve Jorgensen
      #2
      Re: ADO: Can I insert a stored procedure in a transaction

      Sure - no problem. Just use an ADO Command object to execute the stored
      procedure, and make sure everything is using the same Connection instance that
      is handling the transaction. Of course, you need to watch if the stored
      procedures themselves are doing BEGIN TRANSACTION, etc., since this could
      confuse the issue.

      On Thu, 05 Feb 2004 20:39:31 GMT, "Filips Benoit" <benoit.filips@ pandora.be>
      wrote:
      [color=blue]
      >Hi,
      >
      >Can I mix ADO-code (insert, update recordsets) and stored procedures in a
      >transaction?
      >
      >Filip
      >[/color]

        Comment

        Previous template Next
        Working...