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 Server Native Client.
For more information, see on SQLXML 4.0 Programming Concepts and Installing SQL Server 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.