ADO and SQL Server
XML-Related Properties
The Microsoft OLE DB Provider for SQL Server (SQLOLEDB) implements several new provider-specific properties that are used to retrieve XML from Microsoft® SQL Server™ 2000. These properties are available to ADO applications as dynamic properties.
These properties are used to specify the mapping schema against which an XPath query is specified as a command or to specify an XSL file to process the results.
| 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. |
| 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. |
These ADO properties map to standard OLE DB 2.6 properties and are used when retrieving the results of a Command execution as a stream.
| Property Name | Description |
|---|---|
| Output Encoding Property | The Output Encoding property specifies the encoding to use in the stream set or returned by the Execute method. |
| Output Stream Property | The Output Stream property specifies the stream containing the results returned by the Execute method. |