| 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 |
