Hi Sergey,
I remembered the DataExplorer and have found they have code which does what I need (in case anybody needs details the core of the code is in the datamgmt_sql.prg and datamgmt.prg), I guess I now need to understand the code and see how I can apply it in my situation :)
>>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
>