Trasanction opened....?

Erik · Joined: 04 Oct 2007 Posts: 2

Hy guys, I have a little question for you.....

Using ADO I opened a transaction (BeginTrans)
after some other operations I need to test if my transaction was opened
How I can verify it?
Do exist some ADO statement or property that inform on thet transaction
state?

Thank you a lot for your Help
Erik

Archived from group: microsoft>public>data>odbc

Val Mazur · Joined: 04 Oct 2007 Posts: 15

Hi Erik,

You could query SQL Server for level of transaction using next SQL statement

SELECT @@TRANCOUNT

It will return you level of nesting

--
Val Mazur
Microsoft MVP
Check Virus Alert, stay updated
http://www.microsoft.com/security/incident/blast.asp

"Erik" wrote in message@TK2MSFTNGP10.phx.gbl...
> Hy guys, I have a little question for you.....
>
> Using ADO I opened a transaction (BeginTrans)
> after some other operations I need to test if my transaction was opened
> How I can verify it?
> Do exist some ADO statement or property that inform on thet transaction
> state?
>
> Thank you a lot for your Help
> Erik
>
>

vbwonderer · Joined: 04 Oct 2007 Posts: 3

IMHO,Val' solution is not in ADO spirit. What if Erik uses
another (not MS) DBMS ?
The function BeginTrans (in ADO 2.7) returns the level of
nesting (for those DB providers that support nested
transactions).
For DB providers that do not support nested transactions,
calling BeginTrans within an open transaction generates an
error (I suppose).

>-----Original Message-----
>Hi Erik,
>
>You could query SQL Server for level of transaction using
next SQL statement
>
>SELECT @@TRANCOUNT
>
>It will return you level of nesting
>
>--
>Val Mazur
>Microsoft MVP
>Check Virus Alert, stay updated
>http://www.microsoft.com/security/incident/blast.asp
>
>
>"Erik" wrote in message
>@TK2MSFTNGP10.phx.gbl...
>> Hy guys, I have a little question for you.....
>>
>> Using ADO I opened a transaction (BeginTrans)
>> after some other operations I need to test if my
transaction was opened
>> How I can verify it?
>> Do exist some ADO statement or property that inform on
thet transaction
>> state?
>>
>> Thank you a lot for your Help
>> Erik
>>
>>
>
>
>.
>