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_MAC HINE\SOFTWARE\M icrosoft\DataAc cess\Version"

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

MDAC 2#
HKEY_CLASSES_RO OT\TypeLib\{000 00200-0000-0010-8000-00AA006D2EA4}
MDAC 2.1
HKEY_CLASSES_RO OT\TypeLib\{000 00201-0000-0010-8000-00AA006D2EA4}
MDAC 2.5
HKEY_CLASSES_RO OT\TypeLib\{000 00205-0000-0010-8000-00AA006D2EA4}
MDAC 2.6
HKEY_CLASSES_RO OT\TypeLib\{000 00206-0000-0010-8000-00AA006D2EA4}
MDAC 2.7
HKEY_CLASSES_RO OT\TypeLib\{EF5 3050B-882E-4776-B643-EDA472E8E3F2}
MDAC 2.8
HKEY_CLASSES_RO OT\TypeLib\{2A7 5196C-D9EB-4129-B803-931327F72D5C}

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

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

HTH
Tom
Prabhat wrote:

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

[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.

--
Keith
"Prabhat" <no********@hot mail.com> wrote in message
news:uG******** ******@TK2MSFTN GP11.phx.gbl...

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