sql server connect: I need to be able to detect the name of all sql server

Hi

If using ODBC then SQLBrowseConnect will do this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odch06pr_16.asp

John

[quoted text, click to view]

You can use the ListAvailableSQLServers method of SQLDMO, that is the
easiest way.

If using odbc, take a look at:

http://sqldev.net/misc/ListSQLSvr.htm

For both, do not use connection pooling and disable it in your odbc
administrator, because SQLDMO maps to SQLBrowseConnect that does not support
connection pooling.

regards,

Sérgio Monteiro - Brazil
"Hiran Coello" <hcoello@corinsa.hn> escreveu na mensagem
news:1f8401c38446$c6be4000$a401280a@phx.gbl...
[quoted text, click to view]