First published on MSDN on Aug 15, 2017
The OLE DB Driver for SQL Server, or SQL Server Native Client OLE DB Provider, used to connect to SQL Server 2005, 2008, 2008 R2, and SQL Server 2012, has gone out of mainstream support on 7/11/2017. However, Microsoft continues to support OLE DB Driver for SQL Server for workloads targeting SQL Server 2012.
Refer to the following guidelines when opening support requests with Microsoft Support for OLE DB, as shipped with SQL Server Native Client 11:
For OLE DB scenarios where the driver is targeting versions of SQL Server newer than SQL Server 2012 (or version 11), support requests can be opened and will be investigated. For such requests, the following guidelines apply:
If the user is not experiencing any blocking issues, our recommendation is to
continue using OLE DB Driver for SQL Server
If there is a blocking issue with the driver, our recommendation is to experiment using the
SQL Server ODBC driver
. Driver issues observed when using SQL Server versions released after SQL Server 2012 will not be addressed at this moment.
If an application depends on SQL Server database features that were released after SQL Server 2012, such as Multisubnetfailover, Transparent Network IP Resolution, Always Encrypted, Azure AD Authentication, Bulk Copy and Table Value Parameters, our recommendation is to experiment with the
ODBC SQL Server driver
The supportability of OLE DB Driver for SQL Server is still a priority for the SQL Server engineering team, and we will continue to work on ensuring customers are successful in this connectivity option. Further updates will be published in the SQL Server Release Services blog directly by the engineering team.