ADO transaction problem

From: Igor T <igortolstikov_at_hotmail.com>
Date: Thu, 28 Oct 1999 16:21:40 -0500
Message-ID: <7vaep3$pm0$1@canopus.cc.umanitoba.ca>

Hello,

I use ADO and BeginTans(), CommitTrans(). When more then 3 transactions are executed I get the error - Attributes of the Connection Object cannot be set. So the transaction gets aborted. When I do not use transaction the 3rd time, everything works just fine. I tried to manually set connection.Attribute = adAxactCommitRetaining - no luck. I also tried to IsolationLevel property to adXactIsolated - did not work.

Did anyone of you experience a problem like this before? I would appreciate if you could give me any suggesion here.

Thanks,

Igor. Received on Thu Oct 28 1999 - 16:21:40 CDT