Obtaining a list of valid SQL Servers

Results 1 to 2 of 2

Thread: Obtaining a list of valid SQL Servers

  1. #1
    Mike Davidson Guest

    Default Obtaining a list of valid SQL Servers

    Is there any way to query for a listing of SQL Servers currently available on a lan(to populate a dropdown, for instance)? Any info, positive or negative, would be appreciated.<BR><BR>Thanks,<BR> Mike

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default I have done it in VB

    lets see if i can find it<BR><BR><BR>yep here is is<BR><BR>For i= 1 To objSQLApp.ListAnnouncedNetworkSQLServers.Count<BR> cboServers.AddItem objSQLApp.ListAnnouncedNetworkSQLServers(i)<BR>Nex t i<BR><BR>now i had to reference SQLOLE object library if my memory sreves me right. I really cant find the project to check<BR><BR>Maybe you can figgure it out from there <BR><BR>HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts