Oracle 9.2.0.7/10g -> ODBC -> MySQL

[Imanol Lazkano]

Hi,

I'm tryng to connect either Oracle 9i (9.2.0.7) or 10g (10.2.0.1) on AIX 5L to a MySQL Database en SuSE Linux and it seems impossible :).

I've tried to compile MySQL Connector but gcc fails to compile and xlc seems to fail also... So I tried the Compiled version of the connector for AIX 5L. It doesn't work: when I try to extract the dynamic libraries from libmyodbc3.a it extracts the object files (.o's) and unixODBC searches for the whole library.

Any idea? How can I link the .o's into libmyodbc3.so.1?

On AIX 4.3.3 I compiled from source and copied the archive library and extracted the dynamic one. Now, using isql, I can connect to MySQL from my AIX 5L machine but Oracle fails:
SQL> select * from "emp"@suse_mysql;
select * from "emp"@suse_mysql
*
ERROR at line 1:
ORA-02068: following severe error from SUSE_MYSQL
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xlab0001)(PORT=1521)))(CONNECT_DATA=(SID=ODBCMySQL)))

Any Ideas?

Imanol Lazkano