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.

ODBC help

Discussion in 'General Discussion' started by Zion Ahead, Apr 9, 2008.

  1. Zion Ahead

    Zion Ahead Well-Known Member

    Joined:
    Nov 10, 2006
    Messages:
    347
    Likes Received:
    0
    Trophy Points:
    16
    Client is using MS Access 2003 as a front-end to a mysql server database. He is
    able to connect to mysql databases on my local server using ODBC wizard and
    selecting the MySQL ODBC 3.5.1 driver, but is not sure of the correct syntax to
    use to connect remotely to the server.

    What is the syntax to complete the fields in the MS Access ODBC connection
    wizard?

    Port 3306 is open via the firewall as well.

    The fields to be completed to make the connection are:
    Server:
    User:
    Password:

    I've tried the below (replaced my password and database names with example
    info)
    Server:
    http://username:mycPanelPwd@ipaddress



    I tried installing ODBC connector without success

    http://dev.mysql.com/downloads/connector/odbc/3.51.html#linux-x86-32bit-rpms

    Code:
    root@server [~]# rpm -Uvh mysql-connector-odbc-setup-3.51.24-0.x86_64.rpm
    warning: mysql-connector-odbc-setup-3.51.24-0.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
    error: Failed dependencies:
            libX11.so.6()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libXcursor.so.1()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libXext.so.6()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libc.so.6()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libc.so.6(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libc.so.6(GLIBC_2.3)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libdl.so.2()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libdl.so.2(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libgcc_s.so.1()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libgcc_s.so.1(GCC_3.0)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libm.so.6()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libm.so.6(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libodbcinst.so.1()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libpthread.so.0()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libpthread.so.0(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libpthread.so.0(GLIBC_2.3.2)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libstdc++.so.5()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libstdc++.so.5(CXXABI_1.2)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libstdc++.so.5(GLIBCPP_3.2)(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            libz.so.1()(64bit) is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
            mysqlodbcrpmpack is needed by mysql-connector-odbc-setup-3.51.24-0.x86_64
    Code:
    root@server [~]# rpm -Uvh mysql-connector-odbc-3.51.24-0.x86_64.rpm
    warning: mysql-connector-odbc-3.51.24-0.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
    error: Failed dependencies:
            libc.so.6()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libc.so.6(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libc.so.6(GLIBC_2.3)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libcrypt.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libdl.so.2()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libltdl.so.3()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libm.so.6()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libm.so.6(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libnsl.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libodbc.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libodbcinst.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libpthread.so.0()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libpthread.so.0(GLIBC_2.2.5)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libpthread.so.0(GLIBC_2.3.2)(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
            libz.so.1()(64bit) is needed by mysql-connector-odbc-3.51.24-0.x86_64
     
  2. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Did the user add the IP address (or a wildcard thereof) from which they are connecting as having access to the MySQL database via the cPanel interface?
     
    #2 cPanelDavidG, Apr 10, 2008
    Last edited: Apr 10, 2008
  3. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    It's been a long long time since I had to do this. However, once the MyODBC driver is installed, the user will need to setup a server configuration in the ODBC Manager in Windows. As you noted, he'll need to provide a username, password and the server name. The server name is the fully-qualified server name without the http:// portion. Also, as David stated, the user will need to add the IP Address he is connecting from to the Access Hosts for MySQL.

    As for more details, here are some links on doing this:

    http://dev.mysql.com/doc/refman/5.0...ml#myodbc-usagenotes-apptips-microsoft-access
    http://www.ucl.ac.uk/is/mysql/access/
    http://servers.digitaldaze.com/extensions/mysql/access.html
     
  4. devilsoulblack

    Joined:
    Mar 27, 2007
    Messages:
    14
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Chile
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    hi i have the same issues but i need install php_pdo_odbc any idea if cpanel support this ?
     
    #4 devilsoulblack, Apr 23, 2008
    Last edited: Apr 23, 2008
Loading...

Share This Page