LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
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 07-15-2003, 07:41 PM   #1
darius
LQ Newbie
 
Registered: Jul 2003
Location: Montreal
Distribution: Red Hat 8.0
Posts: 2

Rep: Reputation: 0
ODBC connection to MySQL


I have RedHat 8.0 running on my PC, and have installed all packages, including MySQL, MyODBC and UnixODBC, but when I try to connect to the 'test' database using ODBC, I get an error.
I use the following syntax, logged in as root:
[bash]# isql MySQL-test test <enter>
And I get:
[SQLerror] could not SQLconnect.

Does anyone know how I can use ODBC to connect to MySQL, under RedHat 8.0?
 
Old 07-30-2003, 06:59 PM   #2
robreeves
LQ Newbie
 
Registered: Jun 2002
Posts: 4

Rep: Reputation: 0
I have a similar problem - mySQL on Redhat 8, ODBC on Win 2K. The error msg is "Lost connection to mySQL server during query" when I push the test button in ODBC configuration. I'm pretty sure it sees the server, because when I put in a bogus server name I get a different "server not found" error. Any thoughts ?
 
Old 09-29-2003, 06:40 PM   #3
bsdfree47
LQ Newbie
 
Registered: Sep 2003
Location: Texas
Distribution: LinuxMandrake
Posts: 1

Rep: Reputation: 0
I have the same problem as darius, except it happens with FreeBSD. Trying to connect via OpenOffice I get the same message. Since I can connect to MySQL as a regular user with a password I suspect that MySQL must be configured to have it accessed without a password. I'm working in finding out how anybody can connect to the MySQL server without having to issue a password and then I"ll let you know my result. Good luck.
 
  


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 ODBC driver fails when trying to add a DSN to MySQL banjoman Linux - Software 0 01-24-2005 09:59 AM
ODBC/MySQL/OpenOffice linuxfond Linux - Newbie 1 05-09-2004 04:27 PM
MySQL + ODBC + C programming qusestion sleepymish Programming 0 01-13-2004 09:52 AM
odbc connection jstu Linux - General 1 11-12-2002 10:01 AM
ODBC driver for MySql baburaj General 1 06-29-2002 10:52 AM


All times are GMT -5. The time now is 12:45 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration