computer Names and MSDE2K Databases

[lgbjr]

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

 

[Peter Huang [MSFT]]

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.

 

[lgbjr]

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

 

[lgbjr]

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/SQLVBCoder.asp#xx1045446xx

Thanks for your help!!
Lee

 

[Steven Cheng[MSFT]]

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.)