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

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

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

" AAA" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
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

AAA wrote:
> 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.

--
Rinze van Huizen
C-Services Holland b.v.

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

Hope this helps
Ad.

" AAA" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

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.
__________________________________


" AAA" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

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

--

- Sahil Malik [MVP]
Upcoming ADO.NET 2.0 book - http://tinyurl.com/9bync
----------------------------------------------------------------------------
---------------

" AAA" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>