First published on MSDN on Apr 14, 2017
SNAC, or SQL Server Native Client, is a term that has been used interchangeably to refer to ODBC and OLE DB drivers for SQL Server. In essence, current versions are tied to SQL Server support lifecycle itself. Currently Microsoft provides support for a few different versions from a lifecycle standpoint:
The table below outlines the several supported versions and respective lifecycles:
SQL Server Version | Driver Installed | Driver Build Number | End of Mainstream * | End of Support * | ODBC | OLE DB ** | Download Link |
2000 to 2008 | SNAC 10 | 10.0.x | 7/8/2014 | 7/9/2019 | Y | Y | Latest Servicing update for SQL Server 2008 R2 Native Client |
2005 to 2012 | SNAC 11 | 11.0.x | 7/11/2017 | 7/12/2022 | Y | Y | Latest Servicing update for SQL Server 2012 Native Client ODBC Driver 11 for SQL Server - Red Hat Linux |
2005 to 2014 | ODBC 11 | 12.0.x | 7/9/2019 | 7/9/2024 | Y | N | ODBC Driver 11 for SQL Server – Windows only |
2008 to 2016 | ODBC 13 | 13.0.x 13.1.x |
7/13/2021 | 7/14/2026 | Y | N | ODBC Driver 13 for SQL Server - Windows + Linux ODBC Driver 13.1 for SQL Server - Windows + Linux |
* Aligned with SQL Server support lifecycle
** OLE DB available on Windows only
Further details available in Support Policies for SQL Server Native Client and System Requirements, Installation, and Driver Files . On OLE DB specifically, refer to OLE DB Supportability Guidelines .
Microsoft also made available a technical article about Converting SQL Server Applications from OLE DB to ODBC , as well as A Quick Guide for OLE DB to ODBC Conversion .
If you are looking for information about support for TLS 1.2, please refer to KB 3135244 .
Note (10/6/2017): OLE DB is being undeprecated. Read more about it here .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.