This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Cannot access information schema tables via ODBC

I have a Microsoft Access connection to MariaDB 10.5.22. I am using MySQL ODBC 8.0 Unicode driver. I can connect to the database and open all the tables. I can connect to information_schema database successfully but no tables show. MySQL workbench allows me to view the tables in information_schema DB after selecting the option Show MetaData and Internal Schemas. I was hopeful that unchecking Disable Schema Support in ODBC driver optionsd might solve the problem. But no joy. Is it possible to view the tables in Information_Schema and, if so, how? Thanks.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.