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.

Connect to mySQL from DSN using ODBC drivers??

Discussion in 'General Discussion' started by franki, Sep 30, 2003.

  1. franki

    franki Member

    Joined:
    Aug 2, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    A client asked me that. If he can connect to mySQL from DSN with ODBC drivers. I didn't know the answer. Could someone help me? Is it possible or not??

    cPanel.net Support Ticket Number:
     
  2. Jemshi

    Jemshi Well-Known Member

    Joined:
    Sep 11, 2003
    Messages:
    210
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    as far as I know, this is for windows.

    :)

    cPanel.net Support Ticket Number:
     
  3. franki

    franki Member

    Joined:
    Aug 2, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
  4. furtherahead

    furtherahead Member

    Joined:
    Nov 22, 2002
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    myODBC

    Yes -- it works great...

    In one project we completed we successfully connected an MS Access desktop database to mySQL on the web via myODBC in order to import records from the online database and mark the online records as downloaded so that they didn't get downloaded again...

    Its pretty straightforward -- install myODBC, then setup a new DSN using the mySQL Driver

    cPanel.net Support Ticket Number:

    cPanel.net Support Ticket Number:
     
  5. franki

    franki Member

    Joined:
    Aug 2, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Re: myODBC

    You installed myODBC on a Linux server, right?

    cPanel.net Support Ticket Number:
     
  6. franki

    franki Member

    Joined:
    Aug 2, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    I'm completely lost now..
    What do I have to install? x86 RPM myODBC-3.51 on the Linux server OR Windows myODBC-3.51 on my local PC???

    I want to connect FROM my local pc TO the Linux server.
     
  7. jsteel

    jsteel Well-Known Member

    Joined:
    Jul 4, 2002
    Messages:
    646
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Atlanta, GA
    Just have them go to the mysql site and download the mysql odbc driver and install it on their local windows machine that has Access.

    Then have them set up the access hosts entry under the Manage MySQL section of their cPanel so that their remote machine's hostname or IP address (wildcards permitted) is listed.

    Now they can use Access to connect to their MySQL databases. They would use the dataabse and database user they created for the login info, their domain name for the server and the standard 3306 as the port.

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page