SQLXML 4.0 OLEDB Provider

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

Coding

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

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:

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

To see available connection options, navigate to the connection strings reference by the above links.