check if there is a running mssql server on your computer

* can I get some code to check wheater there is a runnung mssql server on a machine

* can i check that for a remote PC  (based on IP adress)

* can I check wheater express or full edition

* can I evaluate the server name ?


---------------  need it as delphi code -------------------------
LVL 8
BdLmAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ThommyConnect With a Mentor Commented:
Enumerating available SQL Servers. Retrieving databases on a SQL Server
http://delphi.about.com/od/sqlservermsdeaccess/l/aa090704a.htm
0
 
ThommyConnect With a Mentor Commented:
Furthermore, to explore the structure of a known MSSQL database you can use this...

Access / SQL Server Database Explorer with full Delphi source code
http://delphi.about.com/library/weekly/aa071205a.htm
0
 
jimyXConnect With a Mentor Commented:
I can't test this but the solution for the first two points is in these links:
http://www.delphi3000.com/articles/article_4052.asp
http://www.delphi3000.com/articles/article_3359.asp?SK=
http://www.delphigroups.info/2/12/178127.html

I did not get what you mean in point three. What do you mean by evaluate the server name?
0
 
BdLmAuthor Commented:
what product has to be installed on the client to use sql Server DMO?
could not find that type lib on my computer, using WIN7 prof. and MSSQL Server Express
0
 
Ephraim WangoyaConnect With a Mentor Commented:

FYI: DMO is to be discontinued (If not discontinued already) so be very careful if you use it

You will be better of finding a solution that uses ADO
0
All Courses

From novice to tech pro — start learning today.