List Servers in Combo Box

A

Alan Z. Scharf

Hi,

Does anyone have samples of how to list SQLServers on network in an ADP
combo box?

Thanks.

Alan
 
S

Sylvain Lafontaine

The usual way of doing this would be to use SQLDMO (also known as SQL-DMO,
search Google for both). The following give you an exemple in .NET for
discovering servers and database using SQLDMO:

http://www.codeproject.com/cs/database/spgen.asp

However, using SQLDMO doesn't mean that you can necessarily discover all
servers on your local machine or onto the network. SQLDMO will look for
things like Alias but to get at all the serverss, the discovery service must
be enabled (SQL-2005) as well as other services for the other machines on
the network (Browser service?).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Creating a Search using a combo box and then creating a report. 4
Combo box 0
Combo or list box 0
Dynamic Naming of Form Button 3
MS Word List Bug 0
Sharepoint not capturing staff name when automation runs 0
Combo or list box 0

Top