Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Enumerating SQL Servers in VFP
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01384624
Message ID:
01384629
Views:
105
I don't think you would be able to enumerate them under all circumstances because SQL 2005 and later installation by default disables SQL Server Browser service which makes enumeration possible.

>I know there was a thread on this 5 years ago but I the solutions presented there are not quite working for me.
>
>I need a means to enumerate and list all the SQL Server accessible to a machine. The solution I saw uses NetServerEnum() which I guess worked fine for SQL Server 2000 but it doesn't properly return names of servers + instances as used by SQL Server 2005.
>
>Any ideas?
>
>PS, I would prefer not to rely on any SQL Server functionality existing on the machine...
>
>Thanks in advance
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform