NetServerEnum returns pointer to buffer, that is hard to use in VFP without additional tools to work with pointers in VFP. SQLBrowseConnect is better here. In addition, I may use it to figure out if I can work with SQL Server at all.
What you meant as 'hidden' SQL Servers?


>>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