My Oracle Support Banner

Problems Selecting Data Dictionary Tables Using DG4ODBC And MySQL 5.1.8 ODBC Driver (Doc ID 1338690.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.


A connection to MySQL works successfully using Database Gateway for ODBC (DG4ODBC) or on Windows and the MySQL 5.1.8 ODBC driver.
However, a select from data dictionary tables such as all_tables, all_objects only returns 1 row instead of the corrrect data for all the tables in the MySQL database.
For example -

SQL> select table_name from user_tables@mysql ;


but there are 23 tables in the MySQL database.
A describe will only return the first column of the table -

SQL> desc "administrative_table"@mysql ;
Name Null? Type
----------------------------------------- --------

column_1 NOT NULL NVARCHAR2(1)

when it has many more.
A select from the table only returns the first column -

select * from "administrative_table"@mysql ;


7891 rows selected.

The problem does not happen with the MySQL ODBC driver 5.1.6 or 3.51.


Update from MySQL ODBC driver 5.1.6 or 3.5.1 to 5.1.8.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.