2022年5月20日 星期五

SQL Server Native Client

 SQL Server Native Client


SQL Server Native Client (SNAC or SQLNCLI)

used to refer to the ODBC and OLE DB drivers for SQL Server

The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to be used for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which is updated and maintained. For SQLNCLI that ships as a component of SQL Server Database engine, see this Support Lifecycle exception


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 2008SNAC 1010.0.x7/8/20147/9/2019YYLatest 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


Reference:

SQL Server Native Client

Installing SQL Server Native Client

SNAC lifecycle explained

Download Microsoft OLE DB Driver for SQL Server

Microsoft® ODBC Driver 11 for SQL Server® - Windows

Microsoft® ODBC Driver 13 for SQL Server® - Windows + Linux

Microsoft® ODBC Driver 13.1 for SQL Server® - Windows, Linux, & macOS


沒有留言:

SQL Server Database Mirroring 資料庫鏡像

SQL Server Database Mirroring 資料庫鏡像