Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Programmatically determine Server and database
Message
De
06/09/2006 14:23:44
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Divers
Thread ID:
01151434
Message ID:
01151455
Vues:
34
Thanks Sergey,

I'll see if I can get one of those to work. I like the idea of using the Windows API, but I'm not sure how I would call it after defining it like this:
DECLARE INTEGER NetServerEnum IN netapi32;
	INTEGER servername, INTEGER level,;
	INTEGER @bufptr, INTEGER prefmaxlen,;
	INTEGER @entriesread, INTEGER @totalentries,;
	INTEGER servertype, INTEGER domain,;
	INTEGER resume_handle
>>Hi,
>>
>>is there a way for me to get a list of available SQL Servers and their corresponding databases so that when my user first runs my application I can prompt them to select the server and database?
>
>Check Re: List of SQL Servers Thread #779753 for different ways to enumerate SQL Servers.
>
>
>- DB list
>SELECT CATALOG_NAME AS DBname FROM INFORMATION_SCHEMA.SCHEMATA
>
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform