Autocommit Isolation Levels Property
The Autocommit Isolation Levels property specifies the transaction isolation levels while in auto-commit mode.
Applies To
| Connection Object |
Syntax
object.Properties("Autocommit Isolation Levels") [= value]
Parts
object
Expression that evaluates to an object in the Applies To list.
value
Integer specifying supported transaction isolation levels as described in Settings.
Settings
A bitmask consisting of zero or more of these settings.
| Constant | Description |
| DBPROPVAL_TI_BROWSE | Equivalent to DBPROPVAL_TI_READUNCOMMITTED |
| DBPROPVAL_TI_CURSORSTABILITY | Equivalent to DBPROPVAL_TI_READCOMMITTED |
| DBPROPVAL_TI_ISOLATED | Equivalent to DBPROPVAL_TI_SERIALIZABLE |
| DBPROPVAL_TI_READCOMMITTED | A transaction operating at the Read Committed level cannot see changes made by other transactions until those transactions are committed. At this level of isolation, dirty reads are not possible, but nonrepeatable reads and phantoms are possible. |
| DBPROPVAL_TI_READUNCOMMITTED | A transaction operating at the Read Uncommitted level can see uncommitted changes made by other transactions. At this level of isolation, dirty reads, nonrepeatable reads, and phantoms are all possible. |
| DBPROPVAL_TI_REPEATABLEREAD | A transaction operating at the Repeatable Read level is guaranteed not to see any changes made by other transactions in values it has already read. At this level of isolation, dirty reads and nonrepeatable reads are not possible, but phantoms are possible. |
| DBPROPVAL_TI_SERIALIZABLE | A transaction operating at the Serializable level guarantees that all concurrent transactions interact only in ways that produce the same effect as though each transaction were entirely executed one after the other. At this isolation level, dirty reads, nonrepeatable reads, and phantoms are not possible. |
Data Type
adInteger
Modifiable
Read/write
OLE DB Property
DBPROP_SESS_AUTOCOMMITISOLEVELS