Support policies for OLE DB Driver for SQL Server
This article discusses how various data-access components can be used with OLE DB Driver for SQL Server.
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.