Listing Available SQL Servers -- sql server connect

Doug
5/6/2004 2:01:27 PM

How does a machine know what SQL servers are available.
For instance: when I create a data link using OLE DB there
is a ComboBox that lists all of the available SQL Servers
to connect to. How does this list get generated and
refreshed? I ask this because I see a particular server in
the list on my PC but I have a coworker whose list does

Dinesh T.K
5/7/2004 2:46:40 AM

Doug,

'Enumerate SQL Servers using OLE-DB'
http://sqldev.net/misc/OleDbEnum.htm

'Enumerate SQL Servers in a domain using the LAN Manager API
NetServerEnum().'
http://sqldev.net/misc/EnumSQLSvr.htm

'Enumerate SQL Server instances on the network using the ODBC
SQLBrowseConnect functionality'
http://sqldev.net/misc/ListSQLSvr.htm

--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com

[quoted text, click to view]

sql server connect : Listing Available SQL Servers