Using the SQLXMLOLEDB Provider (SQLXML 4.0)
The topics in this section provide ADO sample applications that illustrate the use of SQLXMLOLEDB Provider-specific properties.
Application Requirements for SQLXMLOLEDB 4.0 Provider
To create working samples that use SQLXMLOLEDB 4.0, you must do the following:
- Create a Microsoft Visual Basic .exe application and add one of the following references:
- Microsoft ActiveX Data Objects 2.6 Library
- Microsoft ActiveX Data Objects 2.7 Library
- Microsoft ActiveX Data Objects 2.8 Library
- Deploy and install SQLXML 4.0 and the SQL Native Client.
For more information, see on SQLXML 4.0 Programming and Deploying Applications with SQL Native Client.
In This Section
- Executing SQL Queries (SQLXMLOLEDB Provider)
Illustrates the use of the ClientSideXML and xml root properties to execute SQL queries.
- Executing Templates That Contain SQL Queries (SQLXMLOLEDB Provider)
Illustrates the use of the ClientSideXML property.
- Executing XPath Queries (SQLXMLOLEDB Provider)
Illustrates the use of the ClientSideXML, Base Path, and Mapping Schema properties.
- Executing XPath Queries with Namespaces (SQLXMLOLEDB Provider)
Illustrates how to query against namespace-qualified schemas.
- Executing Templates That Contain XPath Queries (SQLXMLOLEDB Provider)
Illustrates how to execute templates with SQL queries using the ClientSideXML, Base Path, and Mapping Schema properties.
- Applying an XSL Transformation (SQLXMLOLEDB Provider)
Illustrates the use of the ClientSideXML and xsl properties in applying an XSL transformation.
See Also
Other Resources
System Requirements for SQL Native Client