ODBC Connection from Oracle on Windows

[Eugene Ang]

Hi,

I've successfully installed MySQL 5.2 on Windows. I've created a new schema called "test" and I can connect from Oracle to MySQL.

select * from information_schema.columns@my01

In the ODBC setting I set the database parameter value to "test". When I try and query the information_schema.columns table connecting via Oracle I get the following error:

ORA-00942: table or view does not exist
[MySQL][ODBC 5.2(a) Driver][mysqld-5.6.14-enterprise-commercial-advanced]Table
'cars_test.columns' doesn't exist {42S02,NativeErr = 1146}
ORA-02063: preceding 2 lines from MY01

If I change the ODBC database parameter value to information_schema it works but I cannot query any of tables for the "test" database.

Is there anyway I can query both schemas?



Edited 1 time(s). Last edit at 10/29/2013 04:43AM by Eugene Ang.