How to install the SQL Server Native Client

When installing SQL Server 2008 or SQL Server, Microsoft SQL Server Native Client 10.0 is installed at the same time. If SQL Server 2005 of SQL Server Native Client is installed on the computer, SQL Server Native Client 10.0 will be installed in parallel with earlier versions.

Microsoft SQL Server Native Client 10.0 download: http://www.jb51.net/database/95927.html.

The SQL Server Native Client file (sqlncli10.dll, sqlnclir10.rll, and s10ch_sqlncli.chm) will be installed in the following locations:

% SYSTEMROOT % \ system32 \

Note:

All corresponding registry settings for the SQL Server Native Client ole db access interface and SQL Server Native Client ODBC driver will be completed during installation.

The SQL Server Native Client header file and library file (sqlncli. h and sqlncli10.lib) are installed in the following locations:

% PROGRAMFILES % \ Microsoft SQL Server \ 100 \ SDK

In addition to installing the SQL Server Native Client as part of the SQL Server installation process, you can also find the redistribution installer named sqlncli. msi in the following locations on the SQL Server installation disk:

% CD % \ Setup \

You can use sqlncli. msi to distribute SQL Server Native clients. When you deploy an application, you may need to install the SQL Server Native Client. One way to install multiple packages (such as one installation for users) is to use the linker and bootstrap technology. For more information, see Authoring a Custom Bootstrapper Package for Visual Studio 2005 (create a Custom boot Package for Visual Studio 2005) and add a Custom system prerequisite.

The x64 and Itanium versions of sqlncli. msi will also install the 32-bit version of SQL Server Native Client. If the target platform for your application is not used during development, you can download the sqlncli. msi version for x64, Itanium, and x86 from the Microsoft download center.

When you call sqlncli. msi, only client components are installed by default. These Client components are files that support running applications developed using SQL Server Native Client. To install the SDK, specify ADDLOCAL = All in the command line. For example:

Msiexec/I sqlncli. msi ADDLOCAL = ALL APPGUID = {0CC618CE-F36A-415E-84B4-FB1BFF6967E1}

Uninstall SQL Server Native Client

Because applications such as SQL Server and SQL Server tools depend on SQL Server Native Client, you can uninstall SQL Server Native Client only after you detach all dependent applications. To warn users that the application depends on SQL Server Native Client, use the APPGUID Installation option in MSI, as shown below:

Msiexec/I sqlncli. msi APPGUID = {0cc618ce-f36a-450e-84b4-fb1bff6967e1}

The value passed to APPGUID is your specific product code. When you use Microsoft Installer to bind an application Installer, you must create the product code.