Support policies for OLE DB Driver for SQL Server
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
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 2022 | SQL Server 2019 | SQL Server 2017 | SQL Server 2016 | SQL Server 2014 | SQL Server 2012 |
|---|---|---|---|---|---|---|---|---|---|
| 19.3.5+ | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 19.3.3+ | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| 19.0+ | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| 18.7.4+ | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 18.6+ | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| 18.2+ | Yes | 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 2022 | Windows Server 2019 | Windows Server 2016 | Windows Server 20121 | Windows Server 2012 R22 | Windows 11 | Windows 10 | Windows 8.13 |
|---|---|---|---|---|---|---|---|---|
| 19.3.3+ | Yes | Yes | Yes | Yes | Yes | |||
| 19.3+ | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| 19.0+ | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| 18.7+ | Yes | Yes | Yes | Yes | Yes | |||
| 18.6+ | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| 18.2+ | Yes | 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 (MSOLEDBSQL19 or MSOLEDBSQL) instead.