473,320 Members | 1,974 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.

List of available SQL servers in the network (SQL Server 2005)

I'd like to present such list to an user, I've tried to use SQLDMO, but
for some reason it shows only the server which is running on my
machine. I know, that there is a couple of threads concerning this
issue, but solutions described there don't work. Any help will be
greatly appreciated.

May 23 '06 #1
3 1302
Hello 12******@wp.pl,

What's wrong? Have u read this KB http://support.microsoft.com/kb/q287737/
I'd like to present such list to an user, I've tried to use SQLDMO,
but for some reason it shows only the server which is running on my
machine. I know, that there is a couple of threads concerning this
issue, but solutions described there don't work. Any help will be
greatly appreciated.

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
May 23 '06 #2
Hello 12******@wp.pl,

C# sample http://www.sqldbatips.com/showarticle.asp?ID=45
I'd like to present such list to an user, I've tried to use SQLDMO,
but for some reason it shows only the server which is running on my
machine. I know, that there is a couple of threads concerning this
issue, but solutions described there don't work. Any help will be
greatly appreciated.

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
May 23 '06 #3
Visual Studio 2005 provides that functionality in the System.Data.SQL
namespace. That way you don't have to use com ; )

"12******@wp.pl" wrote:
I'd like to present such list to an user, I've tried to use SQLDMO, but
for some reason it shows only the server which is running on my
machine. I know, that there is a couple of threads concerning this
issue, but solutions described there don't work. Any help will be
greatly appreciated.

May 24 '06 #4

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

Similar topics

2
by: John D | last post by:
Does anyone have any idea how to syncronise two SQL identical tables across a network, between servers? We want to run our website from a SQL tables on the same server, but set up so that if the...
7
by: steve | last post by:
Can you join two tables across different servers in mySQL, or am I dreaming of Oracle? -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checked...
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...
2
by: JB | last post by:
I'm trying to find out how to create a drop down that lists the Server Names on the network. Much like Sql Server does when choosing some kind of connection, it seems to autodetect them, so I'm...
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...
7
by: EvanK | last post by:
Is there a way to access a list of available sql servers in vb and make a dropdown list?
3
by: mandarkraftware | last post by:
Hi All, We have the following list of consultants currently available. Name / Job Title Summary Ramchandran/Java · 7+ years experience in the field of Software Development. · Expertise in...
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: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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

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.