Microsoft OLE DB Driver for SQL Server

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

Include "Provider=msoledbsql" in the connection string to use this provider.

Description

Microsoft OLE DB Driver for SQL Server was released 2018. It supports the existing features of SQL Server Native Client 11 and connectivity to SQL Server 2012 - 2017, Azure SQL Database and Azure SQL Data Warehouse.

The install package is standalone and is released out-of-band with SQL Server versions. This also means the driver will not be packaged in the SNAC library, nor coupled with any other driver.

Microsoft OLE DB Driver for SQL Server delivers the SQL OLE DB driver in one DLL. It also provides new functionality above and beyond that supplied by the Windows DAC, formerly MDAC. It supports features such as multiple active result sets (MARS), user-defined data types (UDT), query notifications, snapshot isolation, and XML data type.

Microsoft OLE DB Driver for SQL Server is the third generation of OLE DB Drivers for SQL Server. It introduces multi-subnet failover capabilities and includes the latest TLS 1.2 standards. Backwards compatibility with SNAC 11 is maintained.

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

Download

This OLE DB Provider, Microsoft OLE DB Driver for SQL Server, can be downloaded here.

Connection Strings

The Microsoft OLE DB Driver for SQL Server 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 2012Azure SQL Database

Providers

.NET Framework Data Provider for SQL Server Microsoft SqlClient Data Provider 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 SQLXML 4.0 OLEDB Provider .NET Framework Data Provider for OLE DB .NET Framework Data Provider for ODBC SQL Server Native Client 10.0 OLE DB Provider SQL Server Native Client 10.0 ODBC Driver Context Connection SQL Native Client 9.0 OLE DB Provider SQL Native Client 9.0 ODBC Driver 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 Network Protocol for SQL Server Connection All SQL Server SqlConnection Properties When to use the SQL Native Client SQL Server 2012 Data Types Reference Download SQL Server Native Client SQL Server 2000 Data Types Reference SQL Server 2005 Data Types Reference