Isolation Levels Property
The Isolation Levels property specifies the supported transaction isolation levels.
Applies To
| Connection Object |
Syntax
object.Properties("Isolation Levels")
Parts
object
Expression that evaluates to an object in the Applies To list.
Returns
A bitmask containing 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 if 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-only
OLE DB Property
DBPROP_SUPPORTEDTXNISOLEVELS