PDA

Click to See Complete Forum and Search --> : SQL Server 7 servers ?


crow_se
Oct 5th, 2000, 03:09 AM
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

Serge
Oct 5th, 2000, 01:35 PM
Are you talking about SQL Servers that you have registered in Enterprise Manager??? Or list of SQL Servers on the LAN???

crow_se
Oct 6th, 2000, 01:55 AM
Sorry, should have said, any on the LAN. BTW, program uses ADO.
Stuart

Serge
Oct 6th, 2000, 09:20 AM
It is possible only in WindowsNT/2000 environment. Check out the Code Snippet (http://forums.vb-world.net/showthread.php?threadid=32301) I've posted for the similar question.

crow_se
Oct 9th, 2000, 01:56 AM
Thanks for all your help
Stuart