Ask Learn
Preview
Please sign in to use this experience.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 | SNAC Installed | SNAC 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 | SNAC 11 | 12.0.x | 7/9/2019 | 7/9/2024 | Y | N | ODBC Driver 11 for SQL Server – Windows only |
2008 to 2016 | SNAC 13 | 13.0.x13.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.
Please sign in to use this experience.
Sign in