w3schools
  
HOME HTML CSS XML JAVASCRIPT ASP PHP SQL MORE...   References Examples Forum About
BEST WEB HOSTING JustHosts

ADO Mode Property


Connection Object Reference 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

object.Mode

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.
 
Connection Object Reference Complete Connection Object Reference

Stylus Studio® XML Development Environment

stylus

Stylus Studio® 2010 XML Enterprise Suite raises the bar for productivity in XML development tools. Millions of XML developers and data integration specialists turn to Stylus Studio's comprehensive and intuitive XML toolset to tackle today's advanced XML data transformation and aggregation challenges.

stylus
  • XML Pipeline Editor, Debugger and Code Generator
  • DataDirect XML Converters
  • XQuery Mapper, Editor, Debugger, and Profiler
  • XSLT Mapper, Editor, Debugger, Designer, and Profiler
  • Java and C# for .Net Code Generation
  • XML Schema Designer With Documentation Generator
  • XML Editor With Full XPath Integration

Download a free trial now



WEB HOSTING
Best Web Hosting
PHP MySQL Hosting
Top 10 Web Hosting
UK Reseller Hosting
Web Hosting
FREE Web Hosting
Top Web Hosting
Cheap Web Hosting
WEB BUILDING
XML Editor – Free Trial!
FREE Flash Website
FREE Web Templates
EDUCATION
US Web Design Schools
HTML Certification
JavaScript Certification
XML Certification
PHP Certification
ASP Certification
STATISTICS
Browser Statistics
Browser OS
Browser Display
FLIGHT TICKETS
Find the cheapest flight
to any destination now!
SHARE THIS PAGE