-
How to create dblink from oracle to mysql? anyone?
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
there are odbc drivers available for unix and linux
-
I know but... depending on platform you have to pay for them ;-)
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
yes, this is a windows 2000 so has odbc driver
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)
"What is past is PROLOGUE"
-
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
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Hi,
Where can I download ODBC 3.51 for MySql?
Thanks
-
I need to read a table from mysql and insert into oracle table
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|