| title | Using the SQLXMLOLEDB Provider (SQLXML 4.0) | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 03/16/2017 | |||
| ms.prod | sql-server-2016 | |||
| ms.reviewer | ||||
| ms.suite | ||||
| ms.technology |
|
|||
| ms.tgt_pltfrm | ||||
| ms.topic | reference | |||
| helpviewer_keywords |
|
|||
| ms.assetid | fbcefac5-29c9-478b-b0e0-d510b593f446 | |||
| caps.latest.revision | 26 | |||
| author | douglaslMS | |||
| ms.author | douglasl | |||
| manager | jhubbard |
The topics in this section provide ADO sample applications that illustrate the use of SQLXMLOLEDB Provider-specific properties.
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 [!INCLUDEssNoVersion] Native Client.
For more information, see on SQLXML 4.0 Programming Concepts and Installing SQL Server Native Client.
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.