2022年5月20日 星期五

SQL Server Client

 SQL Server Client



1.Net Framework
.Net Framework內建SQL Server驅動程式,引應命名空間System.Data.SqlClient即可連接到SQL Server 2019,開發主機或Laptop不需要額外安裝驅動程式


2.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 Planning, Pricing and License

  Server-CALs授權模式 1.需購買的量應該是所有終端用戶的電腦 例如:一台Data warehouse主機 與 一台Web報表主機,但公司有50人或電腦會連進Web報表主機開啟報表,則應該每一台用戶端電腦都需要有CALs授權,Data warehouse主機購買Ser...