Sql Server 2012 Native Client 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.
In SSIS 2012, our packages use an 'OLE DB SQL Server Native Client 10.0' connection to access the SQL Server 2000 databases (we actually just edited the connection strings and changed Provider from 'SQLNCLI11.1' to 'SQLNCLI10.1'). 'SQL Server 2012 Feature Pack Instructions: The links to the SQL Server 2012 Feature Pack components can be found in the “INSTRUCTIONS” section on the SQL Server 2012 Feature Pack page. - The “INSTRUCTIONS” section can be found about half way down the SQL Server 2012 Feature Pack page.
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.
Code example in C++
Sql Server 2012 Sp2 Native Client Download
The following C++ sample demonstrates how to use the ODBC APIs to connect to and access a database:
Download
Documentation
Features
- SQL Server Native Client (the features available also apply, without OLEDB, to the ODBC Driver for SQL Server)