Hi Stephane ! Thanks for quick answer. But what if several tables participate in the same transaction ? With ODBC we have to use token to bind several connection together. How can this such task be done with ADO.


>Transactions are set at the connection level, oConn.BeginTrans, oConn.CommitTrans and oConn.RollbackTrans.
>
>If you are using COM+ it's much easier to use the built-in transaction support of COM+.
>
>>I know how to how to deal with transactions using ODBC but I want to try to do it with ADO. Does anybody know how to deal with transactions using cursorsoradapters (datasourcetype=ADO) connected to SQLServer backend.
>>I would apreciate a link to such information.
>>(In case of my application several tables participate in the same transaction)