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:

1. 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

2. 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.

See Also

Concepts

System Requirements for SQL Server 2008 R2 Native Client