Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server names list in local network
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Fonctions Windows API
Divers
Thread ID:
00417178
Message ID:
00418183
Vues:
41
>Ok. I found answer, its SQLBrowseConnect function of ODBC API. Thanks for suggestions.
>
>>Setting up an ODBC link does the same thing, it provides a list of local SQL Servers, so I don't know if there's a Windows API that provides this functionality or not.
>>
>>PF
>>
>>>No, I don't need what is in ODBC.
>>> When you run many of SQL Server tool, they prompt you to select SQL Server. It is usually combo box with list of all SQL Servers installed on computers all over the local network. Enterprise Manager application show all these SQL servers in the tree and you can connect to any of these servers.
>>> How to get list of these servers in network?

I know that you found the answer, but I thought I would throw this out for you (and anyone else) anyway. Try looking up the API fuction NetServerEnum. It will list all servers of the specified type that are visible in a domain. I'm pretty sure that this is what all of the SQL Server applications you are refering to use also. It will not show hidden servers, which is what I have witnessed with the SQL application on our domains.

HTH,
REM
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform