--- 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: - "dbe-xml" ms.tgt_pltfrm: "" ms.topic: "reference" helpviewer_keywords: - "sample applications [SQLXML]" - "SQLXMLOLEDB Provider, samples" - "ClientSideXML property" ms.assetid: fbcefac5-29c9-478b-b0e0-d510b593f446 caps.latest.revision: 26 author: "douglaslMS" ms.author: "douglasl" manager: "jhubbard" --- # 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 [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] Native Client. For more information, see on [SQLXML 4.0 Programming Concepts](../../../relational-databases/sqlxml/sqlxml-4-0-programming-concepts.md) and [Installing SQL Server Native Client](../../../relational-databases/native-client/applications/installing-sql-server-native-client.md). ## In This Section [Executing SQL Queries (SQLXMLOLEDB Provider)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/data-access-components-provider/executing-sql-queries-sqlxmloledb-provider.md) Illustrates the use of the ClientSideXML and xml root properties to execute SQL queries. [Executing Templates That Contain SQL Queries (SQLXMLOLEDB Provider)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/data-access-components-provider/executing-templates-that-contain-sql-queries-sqlxmloledb-provider.md) Illustrates the use of the ClientSideXML property. [Executing XPath Queries (SQLXMLOLEDB Provider)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/data-access-components-provider/executing-xpath-queries-sqlxmloledb-provider.md) Illustrates the use of the ClientSideXML, Base Path, and Mapping Schema properties. [Executing XPath Queries with Namespaces (SQLXMLOLEDB Provider)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/data-access-components-provider/executing-xpath-queries-with-namespaces-sqlxmloledb-provider.md) Illustrates how to query against namespace-qualified schemas. [Executing Templates That Contain XPath Queries (SQLXMLOLEDB Provider)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/data-access-components-provider/executing-templates-that-contain-xpath-queries-sqlxmloledb-provider.md) Illustrates how to execute templates with SQL queries using the ClientSideXML, Base Path, and Mapping Schema properties. [Applying an XSL Transformation (SQLXMLOLEDB Provider)](../../../relational-databases/sqlxml-annotated-xsd-schemas-xpath-queries/data-access-components-provider/applying-an-xsl-transformation-sqlxmloledb-provider.md) Illustrates the use of the ClientSideXML and xsl properties in applying an XSL transformation. ## See Also [System Requirements for SQL Server Native Client](../../../relational-databases/native-client/system-requirements-for-sql-server-native-client.md)