thanks for the reply Steven,
Interesting, I loaded the app onto the machine that wasn't showing up in the
list. Even running the app from that machine, the other two servers show up,
but it doesn't! So, I'm stuck. It's obviously not a conectivity issue, since
I can still connect to the DB from the other machines, and I can connect to
the other servers from the "Missing" machine.
I suspect that a quick uninstall/re-install of MSDE on that machine will fix
it, though there's probably an easier way to fix it. Where and how does the
OS actually make available it's ServerType? A registry entry?
TIA
Lee
"Steven Cheng[MSFT]" <v-******@online.microsoft.com> wrote in message
news:%2*****************@TK2MSFTNGXA01.phx.gbl...
Hi Lee,
Welcome to MSDN newsgroup.
As for the one server not display when using NetServerEnum to search all
the existing SQLServers in the network you mentioend, I'm thinking whether
it is a machine specific problem. Does the problem also occur if you try
the same code on some other machine in the network? Also, is there
anything
obviously different on that missing server from the other two servers?
In addition, based on my research we can also use SQLDMO component to
query
all the existing sqlservers. You can have a look at the SQLdmo code in the
following threads and test to see wheher it can retrieve the complete list
or get the same result with the NetServerEnum:
http://www.dotnet247.com/247referenc...31/155355.aspx
If there're any other findings, please also feel free to post here.
Thanks,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)