General information
Category:
Windows API functions
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only