SQLXML 4.0 OLEDB Provider

This OLE DB Provider is provided by Microsoft. The main functionality of the provider is contained in the file Sqlxml4.dll.

Include "Provider=SQLXMLOLEDB.4.0;Data Provider=providername" in the connection string to use this provider.

Description

SQLXML enables XML support for SQL Server Databases. It bridges the gap between XML and relational data. You create an "XML view" of existing relational data and work with it as if it was an XML file.

Starting with SQL Server 2008, SQLXML 4.0 is no longer included in SQL Server (as it was with SQL Server 2005). It is included in the Microsoft SQL Server 2008 Feature Pack or through separate download, see download link below.

Please also note that it might be necessary to include "DataTypeCompatibility=80;" in the connection string for the data types mapping to work correct.

More info about this provider can be found at the Microsoft product page.

Download

This OLE DB Provider, SQLXML 4.0 OLEDB Provider, can be downloaded here.

Connection Strings

The SQLXML 4.0 OLEDB Provider provider can be used to connect to the following data sources by using the following connection string references:

SQL ServerSQL Server 2019SQL Server 2017SQL Server 2016SQL Server 2014SQL Server 2012SQL Server 2008SQL Server 2005

Providers

.NET Framework Data Provider for SQL Server Microsoft SqlClient Data Provider for SQL Server Microsoft OLE DB Driver for SQL Server Microsoft ODBC Driver 17 for SQL Server Microsoft ODBC Driver 13 for SQL Server Microsoft ODBC Driver 11 for SQL Server SQL Server Native Client 11.0 OLE DB Provider SQL Server Native Client 11.0 ODBC Driver SQL Server Native Client 10.0 OLE DB Provider SQL Server Native Client 10.0 ODBC Driver SQL Native Client 9.0 OLE DB Provider SQL Native Client 9.0 ODBC Driver .NET Framework Data Provider for OLE DB .NET Framework Data Provider for ODBC Context Connection Microsoft OLE DB Provider for SQL Server Microsoft SQL Server ODBC Driver SQLXML 3.0 OLEDB Provider MSDataShape

Articles

read all »
The new Microsoft.Data.SqlClient explained Application Name for SQL Server Connections SQL Server Data Types Reference All SQL Server SqlConnection Properties When to use the SQL Native Client Download SQL Server Native Client Network Protocol for SQL Server Connection SQL Server 2012 Data Types Reference SQL Server 2005 Data Types Reference SQL Server 2008 Data Types Reference