List Servers in Combo Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan Z. Scharf - 26 Mar 2007 14:48 GMT

Hi,

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

Thanks.

Alan

Reply to this Message

Sylvain Lafontaine - 27 Mar 2007 17:01 GMT

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?).

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

> Hi,
>
[quoted text clipped - 4 lines]
>
> Alan

Reply to this Message