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
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.