Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

connecting to mysql with ODBC

Discussion in 'General Discussion' started by AbeFroman, Mar 13, 2003.

  1. AbeFroman

    AbeFroman BANNED

    Joined:
    Feb 16, 2002
    Messages:
    654
    Likes Received:
    1
    Trophy Points:
    318
    Hi,

    Is this possible on redhat?

    connecting to mysql with ODBC to edit using Access.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. MarlboroMan

    MarlboroMan Well-Known Member

    Joined:
    Dec 7, 2001
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    306
    Log into the CPanel for the account whose DB you wish to access, and add your home IP to the allowed hosts listing.

    Download and install the MySQL ODBC Driver:
    http://www.mysql.com/downloads/api-myodbc.html

    After installation, go to the control panel on your local PC, open up the ODBC/DSN control panel, and create a system DSN for your MySQL DB using the new driver.

    Start Access, create a new Database, and select File->External Data->Link Tables. Select your DSN, and follow the procedures there.

    Ta-da.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. AbeFroman

    AbeFroman BANNED

    Joined:
    Feb 16, 2002
    Messages:
    654
    Likes Received:
    1
    Trophy Points:
    318
    Do i have to have the access database stored on my home computer at all times?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice