ODBC help

[Zion Ahead]

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

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

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

[cPanelDavidG]

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?

[cpanelkenneth]

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/...crosoft-access
http://www.ucl.ac.uk/is/mysql/access/
http://servers.digitaldaze.com/exten...ql/access.html

[devilsoulblack]

hi i have the same issues but i need install php_pdo_odbc any idea if cpanel support this ?