Getting list of database servers into combo box

[doofy]

Anyone know how I can pull in a list of available database servers on my
computer (which I will then use to populate a combo box)?

Even just the namespace to use would be a start, though more info than
that would be a lot more helpful.

Filling the combo box is something I think I can figure out. Just need
to know how to search for the servers.

The better option is how I could access these common forms used to
connect to databases, where all the layers are asked for in the form,
and at the end you hit a "Test Connection" button. Are those available
via code?

[sloan]

One (crappy) way is to poll this registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\ConnectTo

sqldmo is a key phrase

http://www.google.com/search?hl=en&q...+of+servers%22

"doofy" <no**@notme.comwrote in message
news:47***********************@news.sonic.net...

Anyone know how I can pull in a list of available database servers on my
computer (which I will then use to populate a combo box)?

Even just the namespace to use would be a start, though more info than
that would be a lot more helpful.

Filling the combo box is something I think I can figure out. Just need to
know how to search for the servers.

The better option is how I could access these common forms used to connect
to databases, where all the layers are asked for in the form, and at the
end you hit a "Test Connection" button. Are those available via code?

[sloan]

One more:
http://www.thescripts.com/forum/thread269246.html
"doofy" <no**@notme.comwrote in message
news:47***********************@news.sonic.net...

Anyone know how I can pull in a list of available database servers on my
computer (which I will then use to populate a combo box)?

Even just the namespace to use would be a start, though more info than
that would be a lot more helpful.

Filling the combo box is something I think I can figure out. Just need to
know how to search for the servers.

The better option is how I could access these common forms used to connect
to databases, where all the layers are asked for in the form, and at the
end you hit a "Test Connection" button. Are those available via code?

[doofy]

doofy wrote:

Anyone know how I can pull in a list of available database servers on my
computer (which I will then use to populate a combo box)?

Even just the namespace to use would be a start, though more info than
that would be a lot more helpful.

Filling the combo box is something I think I can figure out. Just need
to know how to search for the servers.

The better option is how I could access these common forms used to
connect to databases, where all the layers are asked for in the form,
and at the end you hit a "Test Connection" button. Are those available
via code?

Thanks for those links. At least now I have an acronym to work with,
and some code.

[doofy]

doofy wrote:

Anyone know how I can pull in a list of available database servers on my
computer (which I will then use to populate a combo box)?

Even just the namespace to use would be a start, though more info than
that would be a lot more helpful.

Filling the combo box is something I think I can figure out. Just need
to know how to search for the servers.

The better option is how I could access these common forms used to
connect to databases, where all the layers are asked for in the form,
and at the end you hit a "Test Connection" button. Are those available
via code?

By the way, that was sincere thanks. I was thinking that "at least now
I have an acronym to work with" sounded sarcastic.

[sloan]

I hear ya dude.

"Tone" is not relayed in emails very well.

It why its a terrible tool for things like conflict resolution or anything
outside of just presenting factual information.

...

But I appreciate the clarification.


"doofy" <no**@notme.comwrote in message
news:47***********************@news.sonic.net...

doofy wrote:

>Anyone know how I can pull in a list of available database servers on my
computer (which I will then use to populate a combo box)?

Even just the namespace to use would be a start, though more info than
that would be a lot more helpful.

Filling the combo box is something I think I can figure out. Just need
to know how to search for the servers.

The better option is how I could access these common forms used to
connect to databases, where all the layers are asked for in the form, and
at the end you hit a "Test Connection" button. Are those available via
code?

By the way, that was sincere thanks. I was thinking that "at least now I
have an acronym to work with" sounded sarcastic.

[Nicholas Paldino [.NET/C# MVP]]

If you don't have access to the SQL DMO objects (or the SQL Management
objects which come with newer versions of SQL server), then you can call the
NetServerEnum API through the P/Invoke layer, looking for the
SV_TYPE_SQLSERVER type.


--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"doofy" <no**@notme.comwrote in message
news:47***********************@news.sonic.net...

Anyone know how I can pull in a list of available database servers on my
computer (which I will then use to populate a combo box)?

Even just the namespace to use would be a start, though more info than
that would be a lot more helpful.

Filling the combo box is something I think I can figure out. Just need to
know how to search for the servers.

The better option is how I could access these common forms used to connect
to databases, where all the layers are asked for in the form, and at the
end you hit a "Test Connection" button. Are those available via code?