odbc

Discussion in 'Installation/Configuration' started by Chad, Apr 10, 2008.

  1. Chad

    Chad New Member

    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:[email protected]



    I tried installing ODBC connector without success

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

    Code:
    [email protected] [~]# 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:
    [email protected] [~]# 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


    Server is using Cpanel, MYSQL 5
     

Share This Page