To download the SQL Server Native Client Drivers package, click the following link as appropriate for the operating system that you are running. For the 32-bit version of SQL Server 2012: 32-bit SQL Server Native Client Drivers package For the 64-bit version of SQL Server 2012: 64-bit SQL Server Native Client Drivers package. Recommended Content. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 R2 features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API. Download sqlncli.msi package (Available for X86 and X64.
Welcome to the Chocolatey Community Package Repository! The packages found in this section of the site are provided, maintained, and moderated by the community.
Moderation
Every version of each package undergoes a rigorous moderation process before it goes live that typically includes:
- Security, consistency, and quality checking
- Human moderators who give final review and sign off
More detail at Security and Moderation.
Organizational Use
If you are an organization using Chocolatey, we want your experience to be fully reliable. Due to the nature of this publicly offered repository, reliability cannot be guaranteed. Packages offered here are subject to distribution rights, which means they may need to reach out further to the internet to the official locations to download files at runtime.
Fortunately, distribution rights do not apply for internal use. With any edition of Chocolatey (including the free open source edition), you can host your own packages and cache or internalize existing community packages.
Disclaimer
Your use of the packages on this site means you understand they are not supported or guaranteed in any way. Learn more...
-->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.
Important
The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features.
Note
For more information and to download the SNAC or ODBC Drivers, see the SNAC lifecycle explained blog post.For more information on ODBC Driver for SQL Server, see Microsoft ODBC Driver for SQL Server.
Information on the SQL Server Native Client features released with SQL Server 2012 (11.x), the last available version of SQL Server native Client:
ODBC in SQL Server Native Client supports three features that were added to standard ODBC in the Windows 7 SDK:
- Asynchronous execution on connection-related operations. For more information, see Asynchronous Execution.
- C Data Type Extensibility. For more information, see C Data Types in ODBC.To support this feature in SQL Server Native Client, SQLGetDescField can return SQL_C_SS_TIME2 (for time types) or SQL_C_SS_TIMESTAMPOFFSET (for datetimeoffset) instead of SQL_C_BINARY, if your application uses ODBC 3.8. For more information, see Data Type Support for ODBC Date and Time Improvements.
- Calling SQLGetData with a small buffer multiple times to retrieve a large parameter value. For more information, see Retrieving Output Parameters Using SQLGetData.
The following topics describe SQL Server Native Client behavior changes in SQL Server 2012 (11.x).
- When calling ICommandWithParameters::SetParameterInfo, the value passed to the pwszName parameter must be a valid identifier. For more information, see ICommandWithParameters.
- SQLDescribeParam will consistently return an ODBC specification conforming value. For more information, see SQLDescribeParam.
See also
Install SQL Server Native Client
SQL Server Native Client Features
SQL Server Native Client Features