Hello,

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

Bye

-- Anonymous, May 30, 2004

Answers

Aistin,

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,

Eric

-- 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