2,250 pts.
POSTED: Feb 1, 2012 2:17 PM (GMT)
That is a very good answer.
Those type of setups were usually called “heterogeneous services”. A google search using those words could offer more info.
Direct queries to mysql 5.0 on Windows Server 2003 from Oracle 10g on Solaris 8
I have Oracle 10g running on Solaris 8. I would like to do direct queries from this server to a table on a MySql 5.0 database residing on a Microsoft Server 2003. Are there step-by-step instructions around? ie. Drivers for both ends; admin/config on both ends, etc. Thanks.
ASKED:
Jan 31, 2012 9:02 PM GMT
UPDATED:
February 28, 2012 10:35:07 AM GMT
RELATED QUESTIONS
- MySQL vs. Oracle
- Select/Insert Statements causing out of memory error run under VB Script
- Can't copy from NFS share to NFS share
- Enabling php_oci8 on win server 2003, IIS 6, fastcgi
- Connect to Oracle 10g with VB6 using ADO
- upgrade database & run application 6i under the web
- Upgrade Oracle 9i to 10g
- Anyone Have Experiences With Running Oracle in a Sun Solaris Container/Zone
- how to transferthe data from higherversion to lowerversion of oracle
- Migration from Oracle 8i (8.1.7 for Win. NT) to Oracle 10g :
Answer Wiki:
I haven't tried this before, but all you should need to do is install MySQL-ODBC and configure a connection between the MySQL and Oracle databases by modifying the odbc.ini files on each server, create an Oracle database link to the MySQL data source, then you should be able to insert, update, delete, and select from Oracle to MySQL across the database link. Here are some instructions that show how to perform this type of set up with Oracle and MySQL both the the same machine (Linux), but you should be able to get the gist of it and be on your way - http://www.dbaglobe.com/2011/05/connect-to-mysql-database-from-oracle.html. I hope that this information is helpful.
To see other answers submitted to the Answer Wiki View Answer History.
