Is there any function in ODBC that i can use to get all the databases name located in MySQL Server. I know there is ODBC_DataSources but it only returns the datasource name, i need the database name because sometimes i have multiple databases and i need to see a list so i can choose. thanks for your help in advance.

Since I don't do ODBC, I know that the
SHOW DATABASES
command work when I'm connected via the mysql interface utility.