| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Support policies for OLE DB Driver for SQL Server |
Learn about the support policies for OLE DB Driver for SQL Server and what operating systems and SQL database versions are supported with each driver version. |
David-Engel |
davidengel |
07/09/2024 |
sql |
connectivity |
reference |
[!INCLUDE SQL Server]
[!INCLUDEDriver_OLEDB_Download]
This article discusses how various data-access components can be used with OLE DB Driver for SQL Server.
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 |
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 applications can use the SQLOLEDB OLE DB provider that is included with Windows if they don't require any of the features of [!INCLUDEssVersion2005] 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 [!INCLUDEssVersion2005] are available when DataTypeCompatibility=80 is present in the connection strings.
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.