By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,899 Members | 1,066 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,899 IT Pros & Developers. It's quick & easy.

computer Names and MSDE2K Databases

P: n/a
Hi All,

I need to retrieve a list of computer names that are available on a network
and a list of databases that are available in MSDE2K. Can someone point me
in the right direction for retrieving this type of info.

TIA!
Lee
Nov 21 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi

Here is a link for your reference.
Enumerate All of the IP Addresses on the Network W/O ActiveDirectory
http://www.codeproject.com/csharp/IPAddresses.asp

If we wants to retrieve the database list from a SQL Server, we just need
to execute the SQL statement as below.
select name from sysdatabases
The sysdatabases table is in the master database.
Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Nov 21 '05 #2

P: n/a
Peter,

thanks for the info. with a bit of work, I now have a treeview that displays
all of the domains and computers on the network

Now, what I need to do is create another treeviw (or combobox) that has a
list of databases available for the computer selected in the treeviwew.

Eventually, I'd like to limit the list of computers in the treeview to those
that have MSDE2K running, but first things first.

How do determine if MSDE2K is running on a computer? Once I know it's
running, I can connect and get the names of the databases available and
display them.

Ultimately, the idea here is to programatically generate a connection string
based on the selected computer and selected database

""Peter Huang" [MSFT]" <v-******@online.microsoft.com> wrote in message
news:Ng**************@TK2MSFTNGXA02.phx.gbl...
Hi

Here is a link for your reference.
Enumerate All of the IP Addresses on the Network W/O ActiveDirectory
http://www.codeproject.com/csharp/IPAddresses.asp

If we wants to retrieve the database list from a SQL Server, we just need
to execute the SQL statement as below.
select name from sysdatabases
The sysdatabases table is in the master database.
Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no
rights.

Nov 21 '05 #3

P: n/a
Hi All,

I found an example that gives me exactly what I was looking for (actually
more than what I was looking for!).

http://www.codeproject.com/vb/net/SQ...sp#xx1045446xx

Thanks for your help!!
Lee

"lgbjr" <lg***@online.nospam> wrote in message
news:OX**************@TK2MSFTNGP12.phx.gbl...
Peter,

thanks for the info. with a bit of work, I now have a treeview that
displays all of the domains and computers on the network

Now, what I need to do is create another treeviw (or combobox) that has a
list of databases available for the computer selected in the treeviwew.

Eventually, I'd like to limit the list of computers in the treeview to
those that have MSDE2K running, but first things first.

How do determine if MSDE2K is running on a computer? Once I know it's
running, I can connect and get the names of the databases available and
display them.

Ultimately, the idea here is to programatically generate a connection
string based on the selected computer and selected database

""Peter Huang" [MSFT]" <v-******@online.microsoft.com> wrote in message
news:Ng**************@TK2MSFTNGXA02.phx.gbl...
Hi

Here is a link for your reference.
Enumerate All of the IP Addresses on the Network W/O ActiveDirectory
http://www.codeproject.com/csharp/IPAddresses.asp

If we wants to retrieve the database list from a SQL Server, we just need
to execute the SQL statement as below.
select name from sysdatabases
The sysdatabases table is in the master database.
Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no
rights.


Nov 21 '05 #4

P: n/a
Thanks for your followup and sharing your resource with us,

Wish you good luck!

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.