| title | SQL Server Native Client | Microsoft Docs | |
|---|---|---|
| ms.date | 04/14/2017 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | e4d4fe39-0090-42a7-8405-6378370d11cb | |
| caps.latest.revision | 43 | |
| author | JennieHubbard | |
| ms.author | jhubbard | |
| manager | jhubbard |
[!INCLUDESNAC_Deprecated]
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.
For more information and to download the SNAC or ODBC Drivers, visit SNAC lifecycle explained.
For more information on ODBC Driver for SQL Server, see Microsoft ODBC Driver for SQL Server on Windows. See also, Introducing the new Microsoft ODBC Drivers for SQL Server, and ODBC Driver 13.1 for SQL Server released.
Information on the [!INCLUDEssNoVersion] Native Client features released with [!INCLUDEssSQL11], the last available version of SQL Server native Client:
ODBC in [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] Native Client behavior changes in [!INCLUDEssSQL11].
-
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.
-
ODBC Driver Behavior Change When Handling Character Conversions
Install SQL Server Native Client
SQL Server Native Client Features