Results 1 to 5 of 5

Thread: SQL Server 7 servers ?

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2000
    Posts
    3
    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

  2. #2
    Serge's Avatar
    Join Date
    Feb 1999
    Location
    Scottsdale, Arizona, USA
    Posts
    2,744
    Are you talking about SQL Servers that you have registered in Enterprise Manager??? Or list of SQL Servers on the LAN???

  3. #3

    Thread Starter
    New Member
    Join Date
    Oct 2000
    Posts
    3

    SQL Server 7 servers ?

    Sorry, should have said, any on the LAN. BTW, program uses ADO.
    Stuart

  4. #4
    Serge's Avatar
    Join Date
    Feb 1999
    Location
    Scottsdale, Arizona, USA
    Posts
    2,744
    It is possible only in WindowsNT/2000 environment. Check out the Code Snippet I've posted for the similar question.

  5. #5

    Thread Starter
    New Member
    Join Date
    Oct 2000
    Posts
    3

    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
  •  



Click Here to Expand Forum to Full Width