Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Programming » OLE DB and ADO development » ADO programming with the OLE DB provider

ADO transactions

By default, any change you make to the database using ADO is committed when it is executed. This includes explicit updates, and the UpdateBatch method on a Recordset.

However, the previous section illustrated that you can use the BeginTrans and RollbackTrans or CommitTrans methods on the Connection object to use transactions.

The transaction isolation level is set as a property of the Connection object. The IsolationLevel property can take on one of the following values:

ADO isolation level Constant Database server isolation level
Unspecified adXactUnspecified Not applicable. Set to 0
Chaos adXactChaos Unsupported. Set to 0
Browse adXactBrowse 0
Read uncommitted adXactReadUncommitted 0
Cursor stability adXactCursorStability 1
Read committed adXactReadCommitted 1
Repeatable read adXactRepeatableRead 2
Isolated adXactIsolated 3
Serializable adXactSerializable 3
Snapshot 2097152 SNAPSHOT
Statement snapshot 4194304 STATEMENT SNAPSHOT
Readonly statement snapshot 8388608 READONLY STATEMENT SNAPSHOT