Direct queries to mysql 5.0 on Windows Server 2003 from Oracle 10g on Solaris 8

5 pts.
Tags:
MySQL 5.0
Oracle 10g
Solaris 8
Windows Server 2003
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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.
    69,160 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following