473,663 Members | 2,876 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

List of SQL Servers Available in a network

Hi all
i need to do a search to all my network to find the SQL servers active, but
i don´t want to use SQLDMO. is there another way to do it ???

THKS

JSB
Nov 17 '05 #1
5 6515
mdb
"João Santa Bárbara" <jo****@i24port ugal.com> wrote in
news:Oe******** ******@TK2MSFTN GP15.phx.gbl:
i need to do a search to all my network to find the SQL servers
active, but i donït want to use SQLDMO. is there another way to do it

http://www.codeproject.com/cs/databa...Enumerator.asp
Nov 17 '05 #2

"mdb" <m_b_r_a_y@c_t_ i_u_s_a__d0t__c om> wrote in message
news:Xn******** *************** *****@207.46.24 8.16...
"João Santa Bárbara" <jo****@i24port ugal.com> wrote in
news:Oe******** ******@TK2MSFTN GP15.phx.gbl:
i need to do a search to all my network to find the SQL servers
active, but i donït want to use SQLDMO. is there another way to do it

http://www.codeproject.com/cs/databa...Enumerator.asp


Waw .... removing SQLDMO dependency in favor of ODBC dependency!.

Willy.
Nov 17 '05 #3
mdb
"Willy Denoyette [MVP]" <wi************ *@telenet.be> wrote in news:e#8j
$w*********@TK2 MSFTNGP12.phx.g bl:
http://www.codeproject.com/cs/databa...Enumerator.asp


Waw .... removing SQLDMO dependency in favor of ODBC dependency!.


:) Haha

What do you want?? Its also dependent on having a network connected! :)
--
-mdb
Nov 17 '05 #4

"mdb" <m_b_r_a_y@c_t_ i_u_s_a__d0t__c om> wrote in message
news:Xn******** *************** *****@207.46.24 8.16...
"Willy Denoyette [MVP]" <wi************ *@telenet.be> wrote in news:e#8j
$w*********@TK2 MSFTNGP12.phx.g bl:
http://www.codeproject.com/cs/databa...Enumerator.asp


Waw .... removing SQLDMO dependency in favor of ODBC dependency!.


:) Haha

What do you want?? Its also dependent on having a network connected! :)
--
-mdb


The problem with this is that OP doesn't mention why he doesn't want to use
SQLDMO, now using ODBC he needs to PInvoke 4 API's, while a simple PInvoke
of a single Win32 API "NetServerE num" could be used to get all SQL servers
in the network without any dependency at all.
Willy.
Nov 17 '05 #5
mdb
"Willy Denoyette [MVP]" <wi************ *@telenet.be> wrote in
news:uV******** ******@TK2MSFTN GP10.phx.gbl:
The problem with this is that OP doesn't mention why he doesn't want
to use SQLDMO, now using ODBC he needs to PInvoke 4 API's, while a
simple PInvoke of a single Win32 API "NetServerE num" could be used to
get all SQL servers in the network without any dependency at all.


Good information... I provided an answer - and the only one I knew at the
time - never said it was the best answer! :)

--
-mdb
Nov 17 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
288
by: Sean W. | last post by:
I want to create a list of MS servers using VB.NET. Where do I start? Also, one I have the list I want to be able to check the diskspace available on each server. This is just for daily auditing of servers in our network. Thanks, Sean
6
1621
by: João Santa Bárbara | last post by:
Hi all i need to do a search to all my network to find the SQL servers active, but i don´t want to use SQLDMO. is there another way to do it ??? THKS JSB
5
5464
by: Oliver Braun | last post by:
I know this is a very common issue and I found a lot of hints on this topic in www but I did not find a very good solution for this task. Most of the solutions use SQLDMO to list all sql servers in the network like this C# code: public static string GetAvailableSQLServers() { // declare arraylist to hold results ArrayList servers = new ArrayList();
1
5053
by: M | last post by:
In .NET (pref. c#) how does one get a list of all available SQL Servers, databases and tables. I need to allow the connection to a database, etc, on the fly. kind of like what happens in SQL Query Analyzer thanks m
1
2469
by: Piotrek Stachowicz | last post by:
Hi, I'd like to display list of all MS SQL servers which are available on the network (I write application which uses database located on one of the machines in my LAN). Has anyone got any idea what to do in order to obtain list of all such servers?! When you open Sql Service Manager (for sql server2000) you've got such list. Thanks,
1
2607
by: Alexander Wehrli | last post by:
Hi, How can I get a list of all Oracle Servers in my network? It isn't possible by calling NetServerEnum, the matching ServerType does not exist. Any idea? Regards Alexander
1
4593
by: Roger | last post by:
I would like to get a list of machines on my network (Workstations and/or Servers). Is there a way to do this in VB.Net? Thanks, Rog
0
2127
by: Mike Cox | last post by:
Andy M wrote: > ALERT > > There is a person by the name of Mike Cox who's trying > to turn this mailing list into a Big-8 newsgroup. No, I'm trying to get teh postgresql groups which are already ON usenet to follow proper usenet guidelines. In order to be under the comp.* hierarchy the server MUST go through RFD and CFV. Otherwise it is a ROGUE group!
16
2458
by: Mike Cox | last post by:
He wants to be in the big 8. He would like to be under the comp.databases.* domain and will not to move it to something like postgresql.*. So he seems to agree with what was my original intention, which was to make the current groups proper members of the big 8. I also offered to let him take over the process as he understands gatewaying and the details better than I. I also offered to let him create the next RFD, and hopefully he...
2
2726
by: querry | last post by:
Hi all, I am trying to get a list of all the available sql servers and then populate them in a combo box. I do this with the following code taken from http://www.csharphelp.com/archives2/archive342.html SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass(); SQLDMO.NameList sqlServers = sqlApp.ListAvailableSQLServers(); for (int i = 0; i < sqlServers.Count; i++) ...
0
8436
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8345
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8771
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8548
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7371
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5657
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4182
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4349
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2000
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.