SQL Server Client in Workstation

[Prabhat]

Hi All,

How can we fine if the SQL Server Client is Installed in the System or Not.
(Using VB and/or Delphi)

As My EXE Require SQL Server Client to Work so I have to Check that If the
Client is Installed or not?

Please Suggest How Can I find If SQL Server 2000 Client IS Installed or NOT
Using VB / VB.NET / Delphi. Please Help.

Thanks for any HELP or Suggestions.
Prabhat

 

[Tom]

As I understand it, it's a question of whether the client has MDAC
installed and perhaps what version. There are three ways that I have
used to determine the version of MDAC.

1) Look in HKEY__LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess\Version"

2) Look for the proper registration of a critical component of MDAC

MDAC 2#
HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}
MDAC 2.1
HKEY_CLASSES_ROOT\TypeLib\{00000201-0000-0010-8000-00AA006D2EA4}
MDAC 2.5
HKEY_CLASSES_ROOT\TypeLib\{00000205-0000-0010-8000-00AA006D2EA4}
MDAC 2.6
HKEY_CLASSES_ROOT\TypeLib\{00000206-0000-0010-8000-00AA006D2EA4}
MDAC 2.7
HKEY_CLASSES_ROOT\TypeLib\{EF53050B-882E-4776-B643-EDA472E8E3F2}
MDAC 2.8
HKEY_CLASSES_ROOT\TypeLib\{2A75196C-D9EB-4129-B803-931327F72D5C}

3) In VB6 create an ADO connection object and ask it

Dim objConn As Object
Set objConn = CreateObject("ADODB.Connection")
Debug.Print objConn.Version

HTH
Tom

 

[Keith Kratochvil]

I am guessing that your app depends on DMO (or something like that) to be
installed by the SQL Server client tools.... The obvious answer would be to
search for isqlw.exe, osql.exe.
This will change when SQL Server 2005 ships, so it might be better to look
for the specific resource file(s) that you need. Or simply show a form
telling (reminding) the user that the SQL Server client tools need to be
installed.