Detect all SQL Server in one network

[AAA]

Hi,

How can I detect all SQL Server, and show all server name in a combo box in
vb.net ?

Thank you very much


Regards

 

[Ken Tucker [MVP]]

Hi,

Add a reference to microsoft sqldmo object library in the com
tab.

Dim sqlServers As SQLDMO.NameList

Dim sqlServer As String

' Get a list of servers

sqlServers = New SQLDMO.Application().ListAvailableSQLServers

For Each sqlServer In sqlServers

Debug.WriteLine(sqlServer)

Next



Ken

-----------------------------

Hi,

How can I detect all SQL Server, and show all server name in a combo box in
vb.net ?

Thank you very much


Regards

 

[C-Services Holland b.v.]

Hi,

How can I detect all SQL Server, and show all server name in a combo box in
vb.net ?

Thank you very much


Regards

Look at this:
http://www.vbcity.com/forums/faq.asp?tid=63836

Using SQLDMO or Net32API.

 

[Adrian Moore]

SQL-Server comes with some example source code. Look under the SQLDMO
examples at the Explorer sample in VB.

Hope this helps
Ad.

 

[William \(Bill\) Vaughn]

This is also supported in ADO.NET 2.0 and I'll be showing a sample on
Saturday...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
www.sqlreportingservices.net
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Sahil Malik [MVP]]

..NET 1.1 - SQLDMO can do this.
..NET 2.0 - Here is how u do it -
http://blogs.msdn.com/sushilc/archive/2004/10/14/242395.aspx