The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    0
    Hi,

    Is this possible on redhat?

    connecting to mysql with ODBC to edit using Access.
     
  2. MarlboroMan

    MarlboroMan Well-Known Member

    Joined:
    Dec 7, 2001
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
  3. AbeFroman

    AbeFroman BANNED

    Joined:
    Feb 16, 2002
    Messages:
    654
    Likes Received:
    1
    Trophy Points:
    0
    Do i have to have the access database stored on my home computer at all times?
     
Loading...

Share This Page