How to enumerate databases?

piggles · Post by **piggles** » 10.08.2007, 22:42

How can I get a list of mysql databases to put in a stringlist so a user can choose one?

Post by **mdaems** » 11.08.2007, 20:21

Try TZConnection.GetCatalogNames ( TStrings List ) or TZConnection::GetSchemaNames (TStrings List )

Not sure which of both works for mysql. Of course, you'll have to connect to the server first.

Also : make sure the user you connect with has sufficient rights to see other databases!!

Mark

piggles · Post by **piggles** » 13.08.2007, 22:23

Thank you! Get CatalogNames is the one.