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)