How to get transaction state?
------------------
sample code
------------------
dim myado as ADODB.Connection
dim myrec as ADODB.Recordset
set myado = new ADODB.Connection
set myrec = new ADODB.Recordset
.
.
.
.
myado.begintrans
'-- Insert code
'-- Here



'-- I want to know the state of transaction ( transaction started or transaction end ).

Help Me....!!!!!