Support policies for OLE DB Driver for SQL Server

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics yesParallel Data Warehouse

DownloadDownload OLE DB Driver

This article discusses how various data-access components can be used with OLE DB Driver for SQL Server.

SQL version support

OLE DB Driver for SQL Server is tested with and supports connections to the following versions of SQL Server.

Database version →
↓ Driver version
Azure SQL Database Azure Synapse Analytics Azure SQL Managed Instance SQL Server 2019 SQL Server 2017 SQL Server 2016 SQL Server 2014 SQL Server 2012
18.5 Yes Yes Yes Yes Yes Yes Yes Yes
18.4 Yes Yes Yes Yes Yes Yes Yes Yes
18.3 Yes Yes Yes Yes Yes Yes Yes Yes
18.2 Yes Yes Yes Yes Yes Yes Yes Yes
18.1 Yes Yes Yes Yes Yes Yes Yes
18.0 Yes Yes Yes Yes Yes Yes Yes
                 

Supported operating system versions

The following table lists which operating systems are supported by OLE DB Driver for SQL Server.

Operating system →
↓ Driver version
Windows Server 2019 Windows Server 2016 Windows Server 20121 Windows Server 2012 R22 Windows 10 Windows 8.13
18.5 Yes Yes Yes Yes Yes Yes
18.4 Yes Yes Yes Yes Yes Yes
18.3 Yes Yes Yes Yes Yes Yes
18.2 Yes Yes Yes Yes Yes Yes
18.1 Yes Yes Yes Yes Yes
18.0 Yes Yes Yes Yes Yes
             

1 Supported on Windows Server 2012 with KB2999226.
2 Supported on Windows Server 2012 R2 with April 2014 update and KB2999226.
3 Supported on Windows 8.1 with April 2014 update and KB2999226.

ADO support policies

ADO applications can use the SQLOLEDB OLE DB provider that is included with Windows if they don't require any of the features of SQL Server 2005 (9.x) or later.

ADO applications can use the OLE DB Driver for SQL Server, but if they do so they must specify DataTypeCompatibility=80 in the connection strings. Only features from SQL Server 2005 (9.x) are available when DataTypeCompatibility=80 is present in the connection strings.

OLE DB support policies

Applications can use the OLE DB provider (SQLOLEDB) included with the Windows operating system. However, that is in maintenance mode and no longer updated. Use the OLE DB Driver for SQL Server (MSOLEDBSQL) instead.

See also

Building applications with OLE DB Driver for SQL Server