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.