By default, any change you make to the database using ADO is committed as soon as it is executed. This includes explicit updates, as well as 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||SQL Anywhere level|
|Unspecified||adXactUnspecified||Not applicable. Set to 0|
|Chaos||adXactChaos||Unsupported. Set to 0|
|Readonly statement snapshot||8388608||6|
For more information on isolation levels, see Isolation levels and consistency.