SQL Server Native client downloads SQL Server Native Client Installation method _mssql2008

When you install SQL Server 2008 or SQL Server Tools, Microsoft SQL Server Native Client 10.0 is installed. SQL Server Native Client 10.0 will be installed in parallel with earlier versions if SQL Server version 2005 of SQL Server Native client is also installed on the computer.

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

SQL Server Native Client files (sqlncli10.dll, Sqlnclir10.rll, and S10ch_sqlncli.chm) will be installed to the following location:

%systemroot%\system32\

Note:

All the appropriate registry settings for the SQL Server Native client OLE DB provider and SQL Server Native client ODBC driver will be completed during the installation process.

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

%ProgramFiles%\Microsoft SQL SERVER\100\SDK

In addition to installing SQL Server Native Client as part of the SQL Server installation process, you can find a redistributable installer named Sqlncli.msi in the following location on the SQL Server installation disk:

%cd%\setup\

You can distribute SQL Server Native Client through Sqlncli.msi. When you deploy an application, you may need to install SQL Server Native Client. One way to install multiple packages (like a single installation for a user) is to use the linker and bootstrapper technology. For more information, see Authoring a custom Bootstrapper Package for Visual Studio 2005 (Authoring a custom bootstrapper package for Visual Studio 2005) and adding custom prerequisites.

The x64 and Itanium versions of Sqlncli.msi also install the 32-bit version of SQL Server Native Client. If your application is targeting a platform that is not the platform that it uses for development, you can download the Sqlncli.msi version for x64, Itanium, and x86 from the Microsoft Download Center.

When Sqlncli.msi is invoked, only the client components are installed by default. These client components are files that support running applications that are developed using SQL Server Native client. If you also want to install the SDK components, specify Addlocal=all on 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 server and SQL Server tools rely on SQL Server Native client, you can uninstall SQL Server Native client only after uninstalling all dependent applications. To provide users with warnings that the application relies on SQL Server Native Client, use the APPGUID installation option in the MSI, as follows:

msiexec/i Sqlncli.msi Appguid={0cc618ce-f36a-415e-84b4-fb1bff6967e1}

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