Newbe - How to lookup databases on server

[Cirunz]

Hi, I have a MSSQL server with various databases on it and I'd like to fill a combo with the list of this databases so the user can choose wich one he want to connect. There is a way to do such a thing?
I think there is because at design time if I select host and protocol in the Object Inspector than I can select the database to connect exactly in this way, but I don't recognize how to do this.
Thank's

[mparak]

I think what you need here is the "show databases" command.
Try it.

You are welcome

Mohammed Parak
CAD RETAIL
Durban South Africa
www.cad.co.za

[mdaems]

Maybe even better : ZConnection.GetSchemanames or GetCatalognames. These functions give TStringLists you can feed directly into a Listbox.

(A quick look at our code in ZPropertyEditor.pas makes me think it's GetCatalogNames.)

Mark