By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

ADO: Can I insert a stored procedure in a transaction

P: n/a
Hi,

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

Filip
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.