|
-
Oct 5th, 2000, 03:09 AM
#1
Thread Starter
New Member
For a project I am involved in I have written a small VB6 program to extract the data from a SQL Server 7 database and create a SQL script to repopulate the tables with this data after a database structure change required by the client.
It is of course straightforward to get a list of databases on the server, but I need to be able to get a list of servers that the workstation can "see", ie. the list shown in the SQL server group in the SQL Server 7 Enterprise Manager. I am assuming at present that the Windows API must be used for this, and was wondering if anyone could point me in the right direction for the required functions.
TIA
Stuart
-
Oct 5th, 2000, 01:35 PM
#2
Are you talking about SQL Servers that you have registered in Enterprise Manager??? Or list of SQL Servers on the LAN???
-
Oct 6th, 2000, 01:55 AM
#3
Thread Starter
New Member
SQL Server 7 servers ?
Sorry, should have said, any on the LAN. BTW, program uses ADO.
Stuart
-
Oct 6th, 2000, 09:20 AM
#4
It is possible only in WindowsNT/2000 environment. Check out the Code Snippet I've posted for the similar question.
-
Oct 9th, 2000, 01:56 AM
#5
Thread Starter
New Member
SQL Server 7 servers ?
Thanks for all your help
Stuart
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|