See SQL Servers

[Alberto]

How can I do to find out the SQL Server availables in my LAN?
I'd like to fill a comboBox control with all the server names.

Thank you.

 

[Guest]

Hi,

Try using SQLDMO ... check out the following

http://www.csharphelp.com/archives2/archive342.html

 

[Lars Wilhelmsen]

Hi Alberto,

How can I do to find out the SQL Server availables in my LAN?
I'd like to fill a comboBox control with all the server names.

IIRC, you can ask your Active Directory server in your domain (if you got
one).
The System.DirectoryServices namespace provides functionality for querying
the AD.

 

[Piotrek Stachowicz]

Hi there,
You may want to see this:
http://www.codeproject.com/csharp/CompPickerLib.asp?msg=864672 .By the way,
I asked almost the same question not so long time ago (actually this is how
I know about this link )

It works really nice, and you can learn a few things about calling unmanaged
code as well - sooner or later you are likely to need this.

Regards,
Piotrek

 

[Tiago Costa]

I have the same problem, i download the exemple but give me this error: "The
type or namespace name'SQLDMO' could not be found....."

I have set the reference .
PS: I convert the solution to VS.NET 2003 (can this cause the problem?!?!?!)

Help please!!!!

 

[Scott]

Here's my preference:
http://www.codeproject.com/cs/database/LocatingSql.asp.

Scott C.