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.
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 |
ASE 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 |