Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 07-15-2003, 08:41 PM   #1
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, 07:59 PM   #2
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, 07:40 PM   #3
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.


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

All times are GMT -5. The time now is 04:58 PM.

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