+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 14
  1. 03-26-2007 01:01 PM #1
    sfgaldba
    sfgaldba is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 03-26-2007 02:36 PM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,504
    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.
    Reply With Quote Reply With Quote
  3. 03-26-2007 02:55 PM #3
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    there are odbc drivers available for unix and linux
    Reply With Quote Reply With Quote
  4. 03-26-2007 03:19 PM #4
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,504
    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.
    Reply With Quote Reply With Quote
  5. 03-26-2007 03:57 PM #5
    sfgaldba
    sfgaldba is offline Junior Member
    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?
    Reply With Quote Reply With Quote
  6. 03-26-2007 04:19 PM #6
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    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"
    Reply With Quote Reply With Quote
  7. 03-26-2007 04:25 PM #7
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,504
    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.
    Reply With Quote Reply With Quote
  8. 03-26-2007 09:05 PM #8
    jennifer2007
    jennifer2007 is offline Banned
    Join Date
    Feb 2007
    Posts
    212
    Hi,

    Where can I download ODBC 3.51 for MySql?

    Thanks
    Reply With Quote Reply With Quote
  9. 03-29-2007 07:37 PM #9
    sfgaldba
    sfgaldba is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  10. 03-30-2007 03:44 AM #10
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    you still havent mentioned what OS you were on
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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