当前位置: 首页 > 网络学院 > 服务端脚本教程 > ADO > ADO IsolationLevel 属性
The IsolationLevel property sets or returns the isolation level of a Connection object. The value is an IsolationLevelEnum value. Default is adXactChaos.
IsolationLevel属性的作用:设置或返回Connection对象的隔离程度。这个值可以是IsolationLevelEnum值中的一个值。默认值为adXactChaos。
Note: The IsolationLevel settings will not work until next time BeginTrans is called.
注意:IsolationLevel仅在下次请求BeginTrans时才会工作。
objconn.IsolationLevel |
<% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.IsolationLevel=adXactIsolated conn.Open(Server.Mappath("northwind.mdb")) response.write(conn.IsolationLevel) conn.Close %> |
Constant常量 | Value值 | Description描述 |
adXactUnspecified | -1 | Cannot use the specified isolation level, because the provider is using a different isolation level, and that level cannot be determined. 指示技术提供对象[provider]正在使用非指定的 IsolationLevel,但其级别无法确定 |
adXactChaos | 16 | Cannot overwrite higher level transactions. 不允许覆盖高等级的事务 |
adXactBrowse | 256 | Can view uncommitted changes in other transactions. 允许查看在其它事务中未授权的改变 |
adXactReadUncommitted | 256 | Same as adXactBrowse. 等同于adXactBrowse |
adXactCursorStability | 4096 | Can view committed changes in other transactions. 允许查看在其它事务中已授权的改变 |
adXactReadCommitted | 4096 | Same as adXactCursorStability. 等同于adXactCursorStability |
adXactRepeatableRead | 65536 | Cannot see changes in other transactions, but you can requery 指示无法从某事务中查看其他事务中所作的更改,但通过查询可以得到新记录集 |
adXactIsolated | 1048576 | Your transactions are isolated from all other transactions. 所有事务相互独立 |
adXactSerializable | 1048576 | Same as adXactIsolated. 等同于adXactIsolated |