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
not contain the server.
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
"Doug" <carrd@.firstenergycorp.com> wrote in message
news:982501c433ad$4c706690$a101280a@.phx.gbl...
> 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
> not contain the server.
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment