How to workaround known issues when connecting to Kintone with ODBC

Problems

Schema and tables are not shown

When you select the below ODBC data source to connect to Kintone from Exploratory,

You might see the below error on the Data Import Dialog and schema and tables are not shown.

Error in new_result(connection@ptr, statement, immediate) : nanodbc/nanodbc.cpp:1412: 42000: The schema name 'information_schema' is invalid.

If this happens, please try the ODBC (Legacy) to work around this issue.