#1  
Old 10th April 2008, 01:43
Chad Chad is offline
Member
 
Join Date: Apr 2007
Posts: 75
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default 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
__________________
Talk Jesus Forums & Live Chat www.talkjesus.com
[ Awesome Facts of Jesus Christ: click here ]
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems building php5 wildgoosed Technical 9 29th August 2007 17:33
Downgrade php5 to php4.4.2 llizards Installation/Configuration 4 13th March 2006 23:58
odbc for sql .... pjm2211 General 2 29th November 2005 23:19


All times are GMT +2. The time now is 12:27.


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