Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











PROPERTY:  Connection::Mode

ConnectModeEnum = connectionobject.Mode
connectionobject.Mode = ConnectModeEnum


The Mode property dictates the provider access permissions for an open connection. It must be set before the connection is opened. This property sets or returns the ConnectModeEnum value. The default is adModeUnknown or zero.
 
ConnectModeEnum Constants
 
Constant Value Description
adModeUnknown 0 Permissions cannot be set or determined
adModeRead 1 Read-only
adModeWrite 2 Write-only
adModeReadWrite 3 Read and write permissions
adModeShareDenyRead 4 Prevents other connections from having read permissions
adModeShareDenyWrite 8 Prevents other connections from having write permissions
adModeShareExclusive 12 Prevents opening other connections
adModeShareDenyNone 16 Permits opening other connections with read/write permissions
adModeRecursive 0x400000 Used in conjunction with the *ShareDeny* constants to set permissions on sub-records

 
Code (VBScript):
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Mode = adModeRead
objRecordset.IsolationLevel = adXactIsolated
...
objConnection.Open strConnect

 


Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information