Server Enumeration

[JD]

I'm looking for a way in VB.NET to enumerat the servers on a network. What
I'm looking for is a way to list my SQLServers. I know I can get this if I
call the NETAPI32.dll and use NETServerEnum. I'm looking for a simple way
of doing this in VB.net.
P.S. Some sample code would be great also.

 

[Shiva]

Another option is to use SQL-DMO (thru COM-interop). A sample is here:
http://www.developersdex.com/gurus/code/262.asp

I'm looking for a way in VB.NET to enumerat the servers on a network. What
I'm looking for is a way to list my SQLServers. I know I can get this if I
call the NETAPI32.dll and use NETServerEnum. I'm looking for a simple way
of doing this in VB.net.
P.S. Some sample code would be great also.

 

[Sijin Joseph]

This should give you an idea on how to go about it
http://www.codeproject.com/cs/combobox/serverdropdown.asp

 

[JD]

This should give you an idea on how to go about it
http://www.codeproject.com/cs/combobox/serverdropdown.asp

This is a C# example do you know if there is a VB.NET example. I do not
have the time to learn C# so I'm looking for a VB.NET.

 

[Shiva]

Here is it: http://www.extremeexperts.com/sql/faq/SQLDMO-ListServers.aspx

This should give you an idea on how to go about it
http://www.codeproject.com/cs/combobox/serverdropdown.asp

This is a C# example do you know if there is a VB.NET example. I do not
have the time to learn C# so I'm looking for a VB.NET.

 

[JD]

http://www.extremeexperts.com/sql/faq/SQLDMO-ListServers.aspx

I know I can do this through SQLDMO, I've done this with VB6. I liked the
C# code that used the NetServerEnum, and was hoping for a VB.net example of
using the NetSeverEnum. I suppose if all else fails I can use the SQLDMO,
but I would like to stay away from that.

 

[Shiva]

Hi,
What about this? http://www.freevbcode.com/ShowCode.asp?ID=6133

Though this code enumerates all computers in the domain, I think changing
the serverType param to SV_TYPE_SQLSERVER should do what you are looking
for.

HTH

http://www.extremeexperts.com/sql/faq/SQLDMO-ListServers.aspx

I know I can do this through SQLDMO, I've done this with VB6. I liked the
C# code that used the NetServerEnum, and was hoping for a VB.net example of
using the NetSeverEnum. I suppose if all else fails I can use the SQLDMO,
but I would like to stay away from that.

 

[JD]

http://www.freevbcode.com/ShowCode.asp?ID=6133

I've had to do some tweeking, but yes this is what I was looking for.
Thank you very much.