HOME
ADO Tutorial
ADO HOME
ADO Intro
ADO Connect
ADO Recordset
ADO Display
ADO Query
ADO Sort
ADO Add
ADO Update
ADO Delete
ADO Demo
ADO Speed Up
ADO Objects
ADO Command
ADO Connection
ADO Error
ADO Field
ADO Parameter
ADO Property
ADO Record
ADO Recordset
ADO Stream
ADO DataTypes
ADO Summary
Examples
ADO Examples
Exam
ADO Exam
Selected Reading
Web Statistics
Web Glossary
Web Hosting
Web Quality
W3Schools Forum
Helping W3Schools
|
ADO IsolationLevel Property
 Complete Connection Object Reference
The IsolationLevel property sets or returns the isolation level of a Connection object.
The value is an IsolationLevelEnum value.
Default is adXactChaos.
Note: The IsolationLevel settings will not work until next time BeginTrans
is called.
Syntax
Example
<%
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
%>
|
IsolationLevelEnum
| 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. |
| adXactChaos |
16 |
Cannot overwrite higher level transactions. |
| adXactBrowse |
256 |
Can view uncommitted changes in other transactions. |
| adXactReadUncommitted |
256 |
Same as adXactBrowse. |
| adXactCursorStability |
4096 |
Can view committed changes in other transactions. |
| adXactReadCommitted |
4096 |
Same as 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. |
Complete Connection Object Reference
|
|
Jump to: Top of Page
or HOME or
Printer friendly page
W3Schools provides material for training only. We do not warrant the correctness of its contents.
The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our
terms of use and
privacy policy.
Copyright 1999-2008 by Refsnes Data. All Rights Reserved.
|
|
|
