Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Programmatically determine Server and database
Message
From
06/09/2006 14:23:44
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01151434
Message ID:
01151455
Views:
33
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform