HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   odbc (http://www.howtoforge.com/forums/showthread.php?t=22177)

Chad 10th April 2008 01:43

odbc
 
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/conne...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



Server is using Cpanel, MYSQL 5


All times are GMT +2. The time now is 09:24.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.