Results 1 to 9 of 9

Thread: odbc?

  1. #1
    Join Date
    Jan 2007
    Posts
    688

    odbc?

    Someone asked this, not sure what to say as I never dealt with ODBC before

    I'm am using MS Access 2003 as a front-end to a mysql server database. I'm able to connect to mysql databases on my local server using ODBC wizard and selecting the MySQL ODBC 3.5.1 driver. But I can't figure out what the correct syntax to use to conect to the database on the server.

    Please let me know if this type of connection is allowed. And if so, what is the syntax to complete the fields in the MS Access ODBC connection wizard.

    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 ifno)
    Server: http://domain:[email protected]

    This is a Cpanel box with Centos 5 / Mysql 5

  2. #2
    Join Date
    Aug 2007
    Location
    Minneapolis
    Posts
    109
    I don't have much experience with this either but the ODBC driver for MySQL should be an interface to talk to MySQL naively, meaning you don't have to install anything on the MySQL server to support this.

    All you need to do is let him connect to the MySQL server remotely, so you'll need to set his user permissions in MySQL to allow him to connect from any REMOTE or local host. Lots of people don't want to do this for the potential security issues since most MySQL passwords are pretty weak.

    So the reason his original attempt failed is because you are blocking these remote connections to your MySQL server.

  3. #3
    Join Date
    Jan 2007
    Posts
    688
    What would be the syntax for the Server, Username and Password? I already opened port 3306 as well

  4. #4
    Join Date
    Jan 2007
    Posts
    688
    What about this?
    http://dev.mysql.com/downloads/conne...x86-32bit-rpms

    I tried doing this, not working for me. I tried rpm'ing both setup and driver files.

    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

  5. #5
    Join Date
    Aug 2007
    Location
    Minneapolis
    Posts
    109
    MySQL is a remote administration client of sorts for the MySQL server. It's NOT what you're looking for. The server address is your regular server address, and username/password are that user's MySQL username and password.

    What you need to do is go into the MySQL configuration and allow that user to connect from any IP address. Usually this is limited to only the local machine (127.0.0.1, localhost) and the machine's "machine name" as well as the fully qualified domain name. You will need to change this. Administration panels allow you to do this easily or you can install Webmin and do it from there.

  6. #6
    Join Date
    Apr 2005
    Location
    Cochin
    Posts
    2,446
    Sam
    Supportlobby.com - Expertise in Windows/Linux server support, IaaS and PaaS Management
    Spiralbean.com - Custom Software Development
    Email: exec @ activelobby.net | Skype: unni_active

  7. #7
    Join Date
    Jan 2007
    Posts
    688
    Client responded with:


    I already have the MySQL ODBC Connector. I need to know exactly what to fill in for the MySQL ODBC screen for the following fields:

    Server:
    User:
    Password:
    Port:
    Socket:
    Initial Statement:

    I've tried several combinations. But no matter what I try, I'm getting:
    [MySQL][ODBC 3.51 Driver]Unknown MySQL server host 'https://ipaddress' (11004)

  8. #8
    Join Date
    Jan 2007
    Posts
    688
    What goes in the Connection Options tab, aside port 3306? Can the ssl / other fields remain blank?
    Attached Thumbnails Attached Thumbnails 1.gif  

  9. #9
    Join Date
    Feb 2004
    Posts
    634
    For the hostname, try using just the IP address or hostname (i.e. don't use "http://" or "https://"). SSL is not required for MySQL connections unless you have a very unusual configuration. Also verify the username/password is in the mysql.user table, and that the host parameter for that user is set to "%" to allow connections from any host IP address.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •