473,320 Members | 1,977 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,320 software developers and data experts.

See SQL Servers

How can I do to find out the SQL Server availables in my LAN?
I'd like to fill a comboBox control with all the server names.

Thank you.
Nov 16 '05 #1
5 2342
Hi,

Try using SQLDMO ... check out the following

http://www.csharphelp.com/archives2/archive342.html


"Alberto" wrote:
How can I do to find out the SQL Server availables in my LAN?
I'd like to fill a comboBox control with all the server names.

Thank you.

Nov 16 '05 #2
Hi Alberto,

"Alberto" <al*****@nospam.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
How can I do to find out the SQL Server availables in my LAN?
I'd like to fill a comboBox control with all the server names.


IIRC, you can ask your Active Directory server in your domain (if you got
one).
The System.DirectoryServices namespace provides functionality for querying
the AD.

--
Lars Wilhelmsen
http://www.sral.org/
Software Engineer
Teleplan A/S, Norway
Nov 16 '05 #3
Hi there,
You may want to see this:
http://www.codeproject.com/csharp/Co...asp?msg=864672 .By the way,
I asked almost the same question not so long time ago (actually this is how
I know about this link :))

It works really nice, and you can learn a few things about calling unmanaged
code as well - sooner or later you are likely to need this.

Regards,
Piotrek
Nov 16 '05 #4
I have the same problem, i download the exemple but give me this error: "The
type or namespace name'SQLDMO' could not be found....."

I have set the reference .
PS: I convert the solution to VS.NET 2003 (can this cause the problem?!?!?!)

Help please!!!!
"gebosw" <ge****@discussions.microsoft.com> escreveu na mensagem
news:18**********************************@microsof t.com...
Hi,

Try using SQLDMO ... check out the following

http://www.csharphelp.com/archives2/archive342.html


"Alberto" wrote:
How can I do to find out the SQL Server availables in my LAN?
I'd like to fill a comboBox control with all the server names.

Thank you.

Nov 16 '05 #5
Here's my preference:
http://www.codeproject.com/cs/database/LocatingSql.asp.

Scott C.
How can I do to find out the SQL Server availables in my LAN?
I'd like to fill a comboBox control with all the server names.

Nov 16 '05 #6

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

Similar topics

1
by: Meghna | last post by:
Hi, I was wondering if some one would be able to help me with this. I am trying to share a session across two servers and I seem to be experiencing some problems. I was wondering if anybody has...
10
by: Captain Ranger McCoy | last post by:
Hello! Suppose I have ten servers at ten ips: x.x.x.1 x.x.x.2 x.x.x.3 x.x.x.4 and so on Each server hosts 100+ photo galleries, all under a single domain name,
2
by: D Barry | last post by:
Greetings: I am trying to conceive what risks might be created by running multiple SQL servers within a domain under a single domain account, as opposed to 1) running under the local service...
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...
3
by: Ben Holness | last post by:
Hi all, I have a php/mysql website where people can upload their own graphics for the buttons and background of pages on the website. This used to run on one server, but I have now been asked...
1
by: Screenbert | last post by:
After finding nothing anywhere in google I am posting this so everyone can benefit by it. The formating is not pretty since I copied it from my word document, but you should benefit by it. ...
0
by: screenbert | last post by:
Managing DHCP Servers using C# They said it was impossible. It couldn't be done. But you can in fact manage DHCP servers using C#. This includes creating and deleting Scopes, SuperScopes,...
13
by: Samir Chouaieb | last post by:
Hello, I am trying to find a solution to a login mechanism for different domains on different servers with PHP5. I have one main domain with the user data and several other domains that need...
1
vvsvinu
by: vvsvinu | last post by:
Iam a sys admin in a firm and iam asked to give a configuration list of a server profile. As there are a lot of new servers now a days and also from the net i got some information still iam confused...
2
vvsvinu
by: vvsvinu | last post by:
Iam a sys admin in a firm and iam asked to give a configuration list of a server profile. As there are a lot of new servers now a days and also from the net i got some information still iam confused...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.