ADO Mode Property
 Complete Connection Object Reference
The Mode property sets or returns a ConnectModeEnum
value that indicates the permission for modifying data in a Connection, Record, or Stream object.
This property is read/write when an object is closed, and read-only when an object is open.
- Connection object - Default is adModeUnknown
- Record object - Default is adModeRead
- Stream object - Default is adModeRead or adModeUnknown
Note: This property can be set only when the Connection object is closed.
Syntax
Example
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Mode=adModeReadWrite
conn.Open(Server.Mappath("northwind.mdb"))
response.write(conn.Mode)
conn.Close
%>
|
ConnectModeEnum
| Constant |
Value |
Description |
| adModeUnknown |
0 |
Permissions have not been set or cannot be determined. |
| adModeRead |
1 |
Read-only. |
| adModeWrite |
2 |
Write-only. |
| adModeReadWrite |
3 |
Read/write. |
| adModeShareDenyRead |
4 |
Prevents others from opening a connection with read
permissions. |
| adModeShareDenyWrite |
8 |
Prevents others from opening a connection with write
permissions. |
| adModeShareExclusive |
12 |
Prevents others from opening a connection. |
| adModeShareDenyNone |
16 |
Allows others to open a connection with any permissions. |
| adModeRecursive |
0x400000 |
Used with adModeShareDenyNone, adModeShareDenyWrite, or
adModeShareDenyRead to set permissions on all sub-records of the current
Record. |
Complete Connection Object Reference
The Altova MissionKit, recent winner of the Jolt Product Excellence and Productivity Award for Best Development Environment,
is an integrated suite of tools ideal for:
- XML development
- Web & Web services development
- Data mapping & integration
- Rendering & publishing XML & database data
- XBRL validation, taxonomy editing, transformation & rendering
The MissionKit for XML Developers includes XMLSpy®, MapForce®, and StyleVision® plus 3 additional tools for less than the price of 2.
Try all 6 products free for 30 days!
Download a fully-functional free trial
|
|
|
|
