Install the SQLServer client driver

I. Three types of SQLServer client Drivers 1. Early drivers integrated into the operating system are known as Microsoft Data Access Components (MDAC) and are built-in drivers in the Windows operating system. 16-bit dynamic

I. Three types of SQLServer client Drivers 1. Early drivers integrated into the operating system are known as Microsoft Data Access Components (MDAC) and are built-in drivers in the Windows operating system. 16-bit dynamic

I. Three SQL Server Client drivers

1. Drivers integrated into the operating system

An early driver, known as Microsoft Data Access Component (MDAC), is a built-in driver in the Windows operating system. The 16-bit dynamic link library (DLL) is SQLSRV. dll, and the 32-bit DLL is SQLSRV32.dll.

Since Vista and Windows Server 2008, the driver is called Windows DAC.

2. SQL Server Native Client

SQL Server 2005 introduces SQL Server Native Client to support new features of SQL Server 2005.

When installing SQL Server 2012 or SQL Server, SQL Server Native Client 11.0 is installed at the same time. You can also obtain sqlncli. msi from the SQL Server feature package page. If the previous SQL Server Native Client Version is installed on the computer, SQL Server Native Client 11.0 will be installed in parallel with earlier versions.

The SQL Server Native Client file (sqlncli11.dll, sqlnclir11.rll, and s11ch_sqlncli.chm) will be installed at: % SYSTEMROOT % \ system32 \

The SQL Server Native Client header file and library file (sqlncli. h and sqlncli11.lib) are installed in the following locations: % PROGRAMFILES % \ Microsoft SQL Server \ 110 \ SDK

Official description

SQL Server Native Client is introduced in SQL Server 2005. It combines the SQL ole db access interface and the SQL ODBC driver into a local DLL. In addition to MDAC compatibility, it also provides new features introduced by SQL Server 2005, such as multiple active result sets (MARS) and user-defined data types (UDT), query notification, Snapshot isolation, and XML data type support.

For the main differences between SQL Server Native Client and MDAC (or Windows DAC), see the official website.

3. ODBC Driver 11

SQL Server 2012 introduces Microsoft ODBC Driver 11 for SQL Server to support new features of SQL Server 2012.

This is a DLL that contains runtime support for applications that use native code APIs to connect to Microsoft SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. Microsoft ODBC Driver 11 for SQL Server should be used to create new applications or to enhance existing applications that need to take advantage of new features of SQL Server 2012.

Ii. Install SQL Server Native Client

1. Use the installation disc

If you have not installed the CD, you can download the SQL Server Express version.

SQL Server 2008 R2 SP2 Express? Id = 30438

SQL Server 2012 SP1 Express? Id = 35579

SQL Server 2014 Express? Id = 42299

2. download and install the Native Client

The SQL Server 2008 R2 feature package provides the following three files:

(1) sqlncli_amd64.msi, used on x64 platform, contains 64-bit and 32-bit drivers, 8.1 MB

(2) sqlncli_ia64.msi, used for the anteng platform, 11.1 MB

(3) sqlncli_x86.msi for x86 Platform, 4.7 MB

SQL Server 2008 R2 SP2 function package? Id = 30440

SQL Server 2012 SP1 function package? Id = 35580

SQL Server 2014 Feature Pack (? Instead of downloading Native Client, we recommend that you install Microsoft ODBC Driver 11 for SQL Server.

The following uses \ x64 \ SQLNCLI.exe in the SQL Server 2012 SP1 function package as an example.

3. Install Microsoft ODBC Driver 11 for SQL Server

Microsoft ODBC Driver 11 for SQL Server this redistributable installer is used to install the client components required during running to take advantage of new features of SQL Server 2012, it can also install the header files required for the development of odbc api applications.

Https://www.microsoft.com/zh-cn/download/details.aspx? Id = 36434

This article is from the "MSSQL we have Chased Together" blog and is not reposted!