Dynamic Properties
The Microsoft OLE DB Provider for SQL Server (SQLOLEDB) inserts a number of dynamic properties into the Properties collection of the unopened Connection, Recordset, and Command objects.
Each of the topics in this section cross-reference a dynamic property with the ADO objects to which it applies, and the corresponding OLE DB property to which it maps. ADO dynamic properties either map to standard OLE DB properties, or to provider-specific OLE DB properties.
Provider-Specific Dynamic Properties
Properties in the form of DBPROP_PROPERTYNAME are standard OLE DB properties. Properties in the form of SSPROP_PROPERTYNAME are provider-specific OLE DB properties. SQLOLEDB supports these provider-specific dynamic properties:
| Property Name | Description |
|---|---|
| Base Path Property | The Base Path property specifies a file path or URL to use for resolving relative paths in a template (for example, XSL on a template root directory, sql:mapping-schema attribute on a sql:xpath:query, external schema references in an inline schema, or Mapping Schema and XML Root properties). |
| Content Type Property | The Content Type property returns the output content type of an XML transmission. |
| Cursor Auto Fetch Property | The Cursor Auto Fetch property specifies whether the initial result set is returned when a cursor is opened. |
| Defer Prepare Property | The Defer Prepare property specifies whether to prepare and perform the initial execution of a statement in a single operation. |
| Mapping Schema Property | The Mapping Schema property specifies a file name or URL that points to the mapping schema used by the provider to translate an XPath command. |
| SS STREAM FLAGS Property | The SS STREAM FLAGS property specifies how an application manages mapping schemas, XSL files, and templates. |
| XML Root Property | The XML Root property provides a root tag in which the query result is wrapped to return a well-formed document. |
| XSL Property | The XSL property specifies an XSL file name or URL applied to the result of a query. |
Examples
Applications reference ADO dynamic properties though the ADO Properties collection using this VBScript syntax:
Dim adoCmd
Set adoCmd = CreateObject("ADODB.Command")
Dim sBasePath
sBasePath = adoCmd.Properties("Base Path")
'Or
adoCmd.Properties("Base Path") = "C:\Inetpub\wwwroot\myvroot\"