How to create dblink from oracle to mysql? anyone?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: How to create dblink from oracle to mysql? anyone?

  1. #1
    Join Date
    Mar 2007
    Posts
    48

    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.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    there are odbc drivers available for unix and linux

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  5. #5
    Join Date
    Mar 2007
    Posts
    48

    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?

  6. #6
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    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"

  7. #7
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  8. #8
    Join Date
    Feb 2007
    Posts
    212
    Hi,

    Where can I download ODBC 3.51 for MySql?

    Thanks

  9. #9
    Join Date
    Mar 2007
    Posts
    48

    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.

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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
  •  


Click Here to Expand Forum to Full Width