?
Solved

check if  there is a running mssql server on your computer

Posted on 2011-03-23
5
Medium Priority
?
504 Views
Last Modified: 2012-05-11
* 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 -------------------------
0
Comment
Question by:BdLm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 19

Accepted Solution

by:
Thommy earned 1000 total points
ID: 35198469
Enumerating available SQL Servers. Retrieving databases on a SQL Server
http://delphi.about.com/od/sqlservermsdeaccess/l/aa090704a.htm
0
 
LVL 19

Assisted Solution

by:Thommy
Thommy earned 1000 total points
ID: 35198501
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
 
LVL 24

Assisted Solution

by:jimyX
jimyX earned 500 total points
ID: 35199945
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
 
LVL 8

Author Comment

by:BdLm
ID: 35205065
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
 
LVL 32

Assisted Solution

by:Ephraim Wangoya
Ephraim Wangoya earned 500 total points
ID: 35238002

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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month14 days, 6 hours left to enroll

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question