The Microsoft ODBC Driver for SQL Server provides native. Microsoft ODBC Driver 11 for SQL Server. Driver 11 for SQL Server installs the client. Jan 19, 2018 Latest servicing update available for the Microsoft® SQL Server® 2012 Native Client.
SQL Server Native Client • • 2 minutes to read • Contributors • • • • • In this article THIS TOPIC APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse 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. NOTE: It is not recommended to use this driver for new development. The new OLE DB provider is called the (MSOLEDBSQL) which will be updated with the most recent server features going forward. For more information and to download the SNAC or ODBC Drivers, visit. For more information on ODBC Driver for SQL Server, see. See also,, and. 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. • C Data Type Extensibility. For more information, see. 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. • Calling SQLGetData with a small buffer multiple times to retrieve a large parameter value. For more information, see. 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. • SQLDescribeParam will consistently return an ODBC specification conforming value. For more information, see.
On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1 (SQLNCLI10.1). I downloaded a native client sqlncli.msi but received the message 'Installation of SQL Server 2008 Native Client failed because a higher version already exists on the machine.' Is there another download to install or is there a way to copy certain files from a server already containing the desired Native Client and then performing the registration without doing a complete reinstallation? Any help would be greatly appreciated.
The First Answer From Sqillman () works! Here's what it solved for us. For us, the answer (above/below?) allows access to SQL Server 2000 databases from SQL Server 2012 Integration Services packages that are hosted on a SQL Server 2012 database server running on Windows Server 2012 OS.
We followed these suggestions to install SQLNCLI10 on our 2012 database server. Our problem occured because the hosting db server never had the old SQL 2008 'SQLNCLI10' installed. That is, it never had SQL Server 2008 installed or an older OS.
The SSIS server error that started our research was: 'The requested OLE DB provider SQLNCLI10.1 is not registered' It is worth noting that when following the solution from squillman/technet/etc, while installing the 2008 SQLNCLI.msi on one of our new servers, we received the error 'Installation of SQL Server 2008 failed because a higher version already exists on the machine.' Despite this, the driver was installed and worked properly without hurting 2012 db server functionality.