Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Enumerating SQL Servers in VFP
Message
From
27/02/2009 14:11:21
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01384624
Message ID:
01384642
Views:
78
Hi Menachem,

I've never tried it out, but here's some code from Andy Kramek:

http://www.foxite.com/archives/get-server-list-0000147442.htm

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

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Reply
Map
View

Click here to load this message in the networking platform