473,396 Members | 2,029 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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 6503
mdb
"Joăo Santa Bárbara" <jo****@i24portugal.com> wrote in
news:Oe**************@TK2MSFTNGP15.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__com> wrote in message
news:Xn****************************@207.46.248.16. ..
"Joăo Santa Bárbara" <jo****@i24portugal.com> wrote in
news:Oe**************@TK2MSFTNGP15.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*********@TK2MSFTNGP12.phx.gbl:
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__com> wrote in message
news:Xn****************************@207.46.248.16. ..
"Willy Denoyette [MVP]" <wi*************@telenet.be> wrote in news:e#8j
$w*********@TK2MSFTNGP12.phx.gbl:
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 "NetServerEnum" 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**************@TK2MSFTNGP10.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 "NetServerEnum" 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
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...
6
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
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...
1
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...
1
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...
1
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
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
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...
16
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...
2
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...
0
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...
0
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...
0
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,...
0
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...
0
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...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.