I want to make connection to mysql from oracle via dblink. Can someone help me? Thanks.:)
Printable View
I want to make connection to mysql from oracle via dblink. Can someone help me? Thanks.:)
Is your Oracle DB running on Windows? if not you are in troubles 'cause you need an ODBC driver.
there are odbc drivers available for unix and linux
I know but... depending on platform you have to pay for them ;-)
What are the steps to set up mysql. I know the defult port for mysql is 3306 isnt it?
what you want to accomplish over the dblink?
functionality:
> ODBC limited (free on windows, license on unix)
> Gateway unlimited (licensed on unix and windows)
Here are my notes...
1- Install ODBC driver 3.51 on Oracle box
2- Create userid on MySQL
3- Setup ODBC connection on Oracle box and test until OK
4- Check Listener, tnsnames and init.ora are setup as per documentation
5- Restart listener
6- Test tnsping until OK
7- Create public MySQL_DBLINK DBLink on Oracle (UserId and Password are case sensitive!!!)
8- Test "select count(*) from anytable@MySQL_DBLINK;" until OK
Hi,
Where can I download ODBC 3.51 for MySql?
Thanks
I need someone who maybe have some experience to help with this. I think dblink would be great so that I dont have to do file upload and download.
you still havent mentioned what OS you were on
My oracle and Mysql on Windows
Both on Windows :rolleyes:
Create user DSN using oracle ODBC or MySQL ODBC drivers, create a dblink and insert data as you require
they both are Windows environment
I have replied but never got updated. They are windows database servers.