Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server names list in local network
Message
General information
Forum:
Visual FoxPro
Category:
Windows API functions
Miscellaneous
Thread ID:
00417178
Message ID:
00418183
Views:
42
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform