I am trying to connect to mysql database through DG4ODBC 11gR2 and have a problem.
When I query tables in the schema other than the one specified in odbc.ini by using a
schema qualified table name, I got table does not exist error. Seems to me DG4ODBC ignore
the schema qualifier, just take the table name, and qualify it with the schema specified
in odbc.ini
For example,
obdc.ini :
[MYSQL]
Driver=MySQL ODBC 5.1 Driver
Server = localhost
PORT = 3306
DATABASE =db1 ###schema db1
USER=user
PASSWORD=pass
select count(*) from "db2"."table2"@MYSQL
ERROR at line 1:
ORA-00942: table or view does not exist
[MySQL][ODBC 5.1 Driver][mysqld-5.0.67-community-log]Table
'db1.table2' doesn't exist {42S02,NativeErr = 1146}
ORA-02063: preceding 2 lines from MYSQL2
It really should translate into 'db2.table2'. It just ignored the schema qualifier db2 here,
and use db1 regardless.
The mysql user can indeed select tables in db1 and db2 in mysql server or through isql of unixODBC.
Plus, in hsodbc of oracle 10gR2, I used schema qualifier all the time and works too.
Did anybody experience similar problem in 11gR2 too?
Thanks,
-Haijun