Geek asks and answers

How to check if SQLNCLI10 provider client is installed while browsing?

I have a C # site that allows a client to directly connect to a remote SQL Server database from their PC , bypassing the web server using a third-party ActiveX control. I originally used the SQLOLEDB provider and it worked fine. Clients are located on the internal network (using Windows machines and Internet Explorer), and the website is not designed to access the general Internet.

I had to switch from the SQLOLEDB provider to the SQLNCLI10 provider in order to service the new data types in SQL Server 2008. It worked on my PC, but broke into production. I did not understand that this worked because the SQLOLEDB provider is part of the Windows OS (MDAC / WDAC) that already exists on the client PC. The SQLNCLI10 provider is included as part of SQL Server 2008 and must be installed separately on the client machine (since most of them will not be installed by SQL Server, but I do).

I can provide a link for them to download the stand-alone Microsoft SQL Server 2008 Native Client provider , but how can I check if they already install it?

+2
source share
2 answers

, Microsoft, , , , . - , , :

HLKM\SOFTWARE\Microsoft\SQLNCLI11 (key:InstalledVersion)
HLKM\SOFTWARE\Microsoft\SQLNCLI10 (key:InstalledVersion)
HKLM\SOFTWARE\Microsoft\Microsoft SQL Native Client\CurrentVersion (version 9, i presume?)
HLKM\SOFTWARE\Microsoft\Microsoft SQL Server Native Client 10.0\CurrentVersion (key:Version)
HLKM\SOFTWARE\Microsoft\Microsoft SQL Server Native Client 11.0\CurrentVersion (key:Version)

MSDN , ( SQL Server Express) , , 200 WMI. WMI .

Microsoft Native Client, , - msi . . , , , 10.5 (!).

SQLNCLI MDAC, msiexec .

+6

  • : HKLM\SOFTWARE\Microsoft\Sqlncli10
  • : sqlncli10.dll \System32

WMI

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\SQLNCLI10\CurrentVersion , , 10.0.1600.22,

+4

More articles:


All Articles