How to enumerate databases?
Posted: 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?
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