How to Check whether ado has already began a transactiongreenspun.com : LUSENET : SQL Server Database Administration : One Thread
In my VB6.0 program at a particular point I'm doing some updation to the database. There i'm using Ado.begintrans at that point I get an error "Can not open more than one transaction" My question is how will i know whether ado has already began a transation
-- Anonymous, May 30, 2004
I do not know of a method or property to check if a transaction has begun. I suggest that you keep track of the state in code or use "On Error GoTo" to handle the case when you would receive the "Can not open more than one transaction" error.
Hope this helps,
-- Anonymous, June 07, 2004
I think you can use select @@trancount to find weather there is any transaction is open. the statement ruturns the count of number of active transactions.
-- Anonymous, June 12, 2004