List SQL Servers in vb.net

List SQL Servers in vb.net

Post by Mario PLeite » Mon, 31 Mar 2003 04:49:29



Hi, I am looking for a function for list all sql servers
in my network, like the function that list all dns of my
odbc
 
 
 

List SQL Servers in vb.net

Post by Marc Scheune » Tue, 01 Apr 2003 18:37:00


On Sat, 29 Mar 2003 11:49:29 -0800, "Mario PLeitez"


>Hi, I am looking for a function for list all sql servers
>in my network,

Your best bet is to use the SQL-DMO functions - add a reference to
SQL-DMO to your VB.NET project, instantiate a SQLDMO.Application
object, and then call the ListAvailableSQLServers method on that
object - it should return a (string) list of available SQL Servers to
you.

Marc

================================================================
Marc Scheuner                        May The Source Be With You!
Bern, Switzerland                         m.scheuner(at)inova.ch