Detect all SQL Server in one network

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

Nov 21 '05 #1

6254

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" <pk***@hotmail.com> wrote in message
news:uk**************@TK2MSFTNGP15.phx.gbl...
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

Nov 21 '05 #2

C-Services Holland b.v.

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.

Nov 21 '05 #3

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.

" AAA" <pk***@hotmail.com> wrote in message
news:uk**************@TK2MSFTNGP15.phx.gbl...

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

Nov 21 '05 #4

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.
__________________________________
" AAA" <pk***@hotmail.com> wrote in message
news:uk**************@TK2MSFTNGP15.phx.gbl...

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

Nov 21 '05 #5

Sahil Malik [MVP]

..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" <pk***@hotmail.com> wrote in message
news:uk**************@TK2MSFTNGP15.phx.gbl...

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

Nov 21 '05 #6

by: ripken95 | last post by:

I connect to the internet through ADSL. I want to write the web page which can detect the connection status with javascript. This detection is like the signal detection in the mobile phone. If the...

Javascript

Detect power redirection to ups

by: Stephane Belzile | last post by:

Is there a way I can detect in vb.Net the power has switched to a UPS unit in case of power failure? Thanks

.NET Framework

How to detect the real status of a socket?

by: Frank Meng | last post by:

Hi. I am trying a csharp sample from http://www.codeproject.com/csharp/socketsincs.asp . (Sorry I didn't post all the source codes here, please get the codes from above link if you want to try)....

C# / C Sharp

How to detect network cable disconnection

by: Vijay | last post by:

Hi all, i have TCP client server application written in C# using async socket methods, eg BeginReceive(), BeginEnd() etc server is continuesly running in the background, client connect to...

C# / C Sharp

detect bytes written on abort

by: Shailesh Humbad | last post by:

Here is an advanced PHP question. Can anyone think of a way to detect the number of bytes written to output when a script is aborted? I am sending a large file to the client, and I want to record...

PHP

Any way to detect a wireless connection and limit it?

by: google | last post by:

Hello, I am working on an Acc2003 app for my company. In the interest of reducing chances of corruption due to unstable network connectivity, I would like to either prevent users from running it...

Microsoft Access / VBA

Need process to detect if network is available

by: BJ | last post by:

Problem: How can I code up a client side process to detect if the network is available? Synopsis: I am writing ASP.NET input forms for a Panasonic Tuff book. The users will be walking around...

ASP.NET

How do I detect networks programatically?

by: jim | last post by:

I need to know if a laptop is connected to the Bellsouth network or the Sprint wireless network. How can this be done with VB.Net 2005?

Visual Basic .NET

Detect in C# the name of the ASP.NET user.

by: =?Utf-8?B?VmlsaGVsbQ==?= | last post by:

I am making a ASP.NET application that connects to a database. I want to distribute this to my customers that may have different Windows OS, so my installer must handle different windows...

ASP.NET

C# - APP - How To Make Server Detect That Client is Disconnected

by: Ontrace | last post by:

hello, I have Problem with Client Server Application when I unplug the client network cable, the server still read the network stream what function should I use to make server detect that the...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Detect all SQL Server in one network

Similar topics