By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,333 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,333 IT Pros & Developers. It's quick & easy.

SQL Server Client in Workstation

P: n/a
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
Nov 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
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

Nov 20 '05 #2

P: n/a
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********@hotmail.com> wrote in message
news:uG**************@TK2MSFTNGP11.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


Nov 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.