As I mentioned above, SQL Server Native Client is the subset of the feature pack. One we open the link for downloading feature pack, click on “Download” button and we get various packages to download. Contains the SQL Server ODBC driver and the SQL Server OLE DB provider in one native dynamic link library (DLL) supporting applications using native-code APIs (ODBC, OLE DB and ADO) to Microsoft SQL Server. 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 Microsoft OLE DB Driver for SQL Server. Hi all, I am trying to install SCCM 2012 on win server 2008.below is the scenario. DC= domain controller + SQL server 2008 SP2 with CU 6. SCCM03 = SCCM server. SQL Server Native Client 11.0 download for Windows 7 32 bit It is suppose to work. After searching an hour, MS claims it can be installed as part of the new SQL Server in one of the directories. Microsoft SQL Server Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. What do see is instructions to download and install SQL 2008 and through the sqlncli.dll file, extract SQL Native Client 10 from that. Let me know if you need more information Popular Topics in Microsoft SQL Server.

Good day.

We have Windows Server 2008 R2 Enterprise X64 and SQL SERVER 2005

Also we install php5.4 VC9 x86 Non Thread Safe and sqlsrv for this version.

Install Microsoft Sql Server Client

When we make connect to server we get error:

As we can see need install Microsoft SQL Server 2012 Native Client ODBC driver for x86 but when we have system x-64 and when we start installer we get error that installer x86 is not suitable for my operation system(for x64).

Anybody know what we should do for close problem?

P.S.:

link on phpinfo - http://194.58.88.58/test.php

link on error http://view-source:http://194.58.88.58/

2 Answers

The message is incorrect. It should not reference the x86 version. You need the x64 version.

See:

Download and install Microsoft SQL Server 2012 Native Client ODBC driver for x86:http://www.microsoft.com/en-us/download/details.aspx?id=36434

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.

Important

The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features.

Note

For more information and to download the SNAC or ODBC Drivers, see the SNAC lifecycle explained blog post.For more information on ODBC Driver for SQL Server, see Microsoft ODBC Driver for SQL Server.

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 Asynchronous Execution.

• C Data Type Extensibility. For more information, see C Data Types in ODBC.

  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 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.

/jen-titus-o-death-cw.html. 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 ICommandWithParameters.

• SQLDescribeParam will consistently return an ODBC specification conforming value. For more information, see SQLDescribeParam.

Install Microsoft Sql Server 2012 Native Client

See also

Install Microsoft Sql Server Native Client Login

Install SQL Server Native Client
SQL Server Native Client Features