This discussion is archived
0 Replies Latest reply: Oct 17, 2013 10:58 PM by user559175 RSS

Oracle 64bit to MySQL (OS 64bit) - Database Link

user559175 Newbie
Currently Being Moderated

My task is to create a database link from Oracle to MySQL.

 

My current setup is:

Windows Server 2008 - 64bit

Oracle 10.2.0.4.0 - 64bit

MySQL 5.0.45-community-nt

 

On my server I have installed the mysql odbc driver 64bit (5.6).

However, this driver only appears in the system32 of the odbcad32.exe and NOT in the syswow64.

 

How is that? I realize the problem might be here since Oracle (a 64bit application) looks for an odbc from a 64bit driver. This is not found since the mysql driver doesnt exist in the odbcad32.exe of syswow64.

 

I have followed the step by step setup procedure from this Connecting Oracle with MS-Access | Oracle FAQ but used the above driver and odbc accordingly.

 

After creating the database link on oracle I execute a select statement and this is the message I get:

 

ERROR at line 2: ORA-28545: error diagnosed by Net8 when connecting to an agent

Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQL_DB

 

MYSQL_DB is the database link created in Oracle.

 

Any ideas? Is this possible? Are there any alternative ways?

 

 

Thank you,

Andreas

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points