Redigera

Dela via


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)

Download 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 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.

See also

Building applications with OLE DB Driver for SQL Server