LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 04-09-2008, 07:43 PM   #1
I_AM
Member
 
Registered: Mar 2005
Posts: 103

Rep: Reputation: 15
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
 
Old 04-09-2008, 07:55 PM   #2
billymayday
LQ Guru
 
Registered: Mar 2006
Location: Sydney, Australia
Distribution: Fedora, CentOS, OpenSuse, Slack, Gentoo, Debian, Arch, PCBSD
Posts: 6,678

Rep: Reputation: 122Reputation: 122
hat distro are you running?
 
Old 04-09-2008, 07:55 PM   #3
I_AM
Member
 
Registered: Mar 2005
Posts: 103

Original Poster
Rep: Reputation: 15
Sorry, its Centos 5
 
Old 04-09-2008, 08:09 PM   #4
billymayday
LQ Guru
 
Registered: Mar 2006
Location: Sydney, Australia
Distribution: Fedora, CentOS, OpenSuse, Slack, Gentoo, Debian, Arch, PCBSD
Posts: 6,678

Rep: Reputation: 122Reputation: 122
Then have you tried using yum to install the connector?

Failing that, try

yum whatprovides libc.so

and so on, and use yum to install the dependencies

Last edited by billymayday; 04-09-2008 at 08:10 PM.
 
Old 04-09-2008, 08:15 PM   #5
I_AM
Member
 
Registered: Mar 2005
Posts: 103

Original Poster
Rep: Reputation: 15
Just curious, shouldnt' the connector actually be installed on the client's local Windows computer?
 
Old 04-09-2008, 08:38 PM   #6
billymayday
LQ Guru
 
Registered: Mar 2006
Location: Sydney, Australia
Distribution: Fedora, CentOS, OpenSuse, Slack, Gentoo, Debian, Arch, PCBSD
Posts: 6,678

Rep: Reputation: 122Reputation: 122
I'd have thought it was server side since Windows clients tend to be able to connect to ODBC sources. Haven't used it myself though, so not certain
 
Old 04-10-2008, 06:47 AM   #7
billymayday
LQ Guru
 
Registered: Mar 2006
Location: Sydney, Australia
Distribution: Fedora, CentOS, OpenSuse, Slack, Gentoo, Debian, Arch, PCBSD
Posts: 6,678

Rep: Reputation: 122Reputation: 122
I checked a CentOS machine, and the connector is in the base repo, so

yum install mysql-connector-odbc

should get you there
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql and odbc Murdock1979 Linux - Server 1 01-09-2008 09:42 AM
how to set odbc Raakh Linux - Newbie 6 06-04-2007 07:27 AM
Odbc Db2 rsz Linux - Software 0 11-14-2006 08:59 AM
Using ODBC to MS SQL ejennings_98 Linux - Software 7 08-05-2005 01:10 PM
ODBC drivers mabus92920 Linux - Newbie 3 01-23-2005 03:58 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 05:51 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration