| title | Microsoft ODBC Driver for SQL Server | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 02/05/2019 |
| ms.prod | sql |
| ms.prod_service | connectivity |
| ms.reviewer | |
| ms.technology | connectivity |
| ms.topic | conceptual |
| ms.assetid | 9f2ae91b-06af-4c9a-9d24-062df7bc4662 |
| author | David-Engel |
| ms.author | v-daenge |
[!INCLUDEODBC_Current_Version]
[!INCLUDEDriver_ODBC_Download]
ODBC is the primary native data access API for applications written in C and C++ for SQL Server. There is an ODBC driver for most data sources. Other languages that can use ODBC include COBOL, Perl, PHP, and Python. ODBC is widely used in data integration scenarios.
The ODBC driver comes with tools such as sqlcmd and bcp. The sqlcmd utility lets you run Transact-SQL statements, system procedures, and SQL scripts. The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a format you choose. You can use bcp to import many new rows into SQL Server tables or to export data out of tables into data files.
The following C++ sample demonstrates how to use the ODBC APIs to connect to and access a database:
- Custom Keystore Providers
- Data Classification
- DSN and Connection String Keywords and Attributes
- SQL Server Native Client (the features available also apply, without OLEDB, to the ODBC Driver for SQL Server)
- Using Always Encrypted
- Using Azure Active Directory
- Using Transparent Network IP Resolution
- Using XA Transactions
- Installing the driver on Linux
- Installing the driver on macOS
- Connecting to SQL Server
- Connecting with bcp
- Connecting with sqlcmd
- Data Access Tracing
- Frequently Asked Questions
- Installing the Driver Manager
- Known Issues
- Programming Guidelines
- Release Notes
- Support for High Availability and Disaster Recovery
- Using Integrated Authentication (Kerberos)