sql-server-native-client-odbc.md

title	ODBC
ms.custom
ms.date	03/17/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology	native-client
ms.topic	reference
helpviewer_keywords	SQLNCLI, ODBC SQL Server Native Client ODBC driver, about SQL Server Native Client ODBC driver data access [SQL Server Native Client], ODBC SQL Server Native Client ODBC driver ODBC SQL Server Native Client, ODBC ODBC, about SQL Server Native Client ODBC driver
ms.assetid	811d5ba3-a2b8-48c0-adbc-8c91f041f458
author	markingmyname
ms.author	maghan
monikerRange	>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

SQL Server Native Client (ODBC)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]

ODBC is a standard definition of an application programming interface (API) used to access data in relational or indexed sequential access method (ISAM) databases. [!INCLUDEssNoVersion] supports ODBC, via the [!INCLUDEssNoVersion] Native Client ODBC driver, as one of the native APIs for writing C and C++ applications that communicate with [!INCLUDEssNoVersion].

[!INCLUDEssNoVersion] programs that are written using the [!INCLUDEssNoVersion] Native Client ODBC driver communicate with [!INCLUDEssNoVersion] through C function calls. The [!INCLUDEssNoVersion]-specific versions of the ODBC functions are implemented in the [!INCLUDEssNoVersion] Native Client ODBC driver. The driver passes SQL statements to [!INCLUDEssNoVersion] and returns the results of the statements to the application.

The [!INCLUDEssNoVersion] Native Client ODBC driver complies with the Microsoft Win32 ODBC 3.51 specification. The driver supports applications written using earlier versions of ODBC in the manner defined in the ODBC 3.51 specification.

In This Section

• Data Source Names and 64-Bit Operating Systems

• Creating a SQL Server Native Client ODBC Driver Application

• Communicating with SQL Server (ODBC)

• Executing Queries (ODBC)

• Processing Results (ODBC)

• Using Cursors (ODBC)

• Performing Transactions (ODBC)

• Handling Errors and Messages

• Running Stored Procedures

• Using Catalog Functions

• Performing Bulk Copy Operations (ODBC)

• Managing Text and Image Columns

• Profiling ODBC Driver Performance

• Table-Valued Parameters (ODBC)

• Date and Time Improvements (ODBC)

• Large CLR User-Defined Types (ODBC)

• FILESTREAM Support (ODBC)

• Service Principal Names (SPNs) in Client Connections (ODBC)

• Sparse Columns Support (ODBC)

• SQL Server Native Client (ODBC) Reference

• ODBC How-to Topics

See Also

SQL Server Native Client Programming
Installing SQL Server Native Client