Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Enumerating SQL Servers in VFP
Message
De
27/02/2009 14:11:21
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01384624
Message ID:
01384642
Vues:
77
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform