ADO: Can I insert a stored procedure in a transaction

[Filips Benoit]

Hi,

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

Filip

[Steve Jorgensen]

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" <be***********@pandora.be>
wrote:

Hi,

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

Filip