I'm using Microsoft Query and I want to connect tables from two different servers.
One uses Oracle in OraClient11g_home1 and the other MySQL ODBC 5.1 Driver.
Both have DSN setup, a different user and password, one with data source name and the other with an ip and port.
Note that most answers out there might not work with MS Query and Oracle.