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 Tutorials
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
 |
 |
 |
 |
|
The Ektron Intranet
lets you do everything you need to do on your corporate intranet and everything you want to do... all with just one application.
What can you do with the Ektron Intranet? |
 |
Navigate through content, documents, assets, colleagues and workgroups quickly and intuitively with enterprise search |
 |
Communicate with friends and colleagues with forums, message boards and corporate blogging using the new Social Networking Platform |
|
Utilize the extensive out-of-the box features or customize your site through Ektron CMS400.NET's open architecture |
 |
Promote collaboration in your organization through project workspaces where others can efficiently find information and work together |
 |
Author/edit content, manage navigation, menus, audit trails, workflow and approvals with the best in breed Content Management |
|
|
|
|
See why there are 20,000+ Ektron integrations worldwide.
|
|
 |
TAKE THE VIDEO TOUR |
 |
or download a FREE TRIAL today. |
|
|
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.
|
|
|
HOME
