Support policies for OLE DB Driver for SQL Server

APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse 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.

Server support

OLE DB Driver for SQL Server supports connections to SQL Server 2012 (11.x) through SQL Server 2017, and Azure SQL Database.

Supported operating system versions

The following table lists which operating systems support OLE DB Driver for SQL Server.

Supported operating systems
Microsoft Windows 8.1 + April 2014 update + KB2999226

Microsoft Windows 10

Microsoft Windows Server 2012 + KB2999226

Microsoft Windows Server 2012 R2 + April 2014 update + KB2999226

Microsoft Windows Server 2016

Microsoft Windows Server 2019

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