View Full Version : QT 4.5 QMYSQL and Mysql 4.1 servers does not work

14th May 2009, 09:58

i'd try to connect with QMYSQL to various mysql databases. When mysql is a server 5.x all work fine.

When I try to connect to mysql 4.1.x following happens:

1. connection establish, login succed
2. trying getting database list with "show databases" - no result. When doing the same from console with mysql5 client (of course same user and password) I get a list of databases.
3. same when I try to get list of tables for a database.

As said: with connection to mysql 5 works fine. On connection to mysql 4 the query is marked as to be not a select. same when I try to get variables with "show variables".

Looks like the "show" statement has some problems with QMYSQL and mysql 4.1.x server? Any hints how to solve it? May be connection parameters?

(as said before: with console app from mysql it works perfekt as expected)


21st July 2009, 16:53
Hi -

I don't know if you've solved your problem or not but it appears that the MySQL driver was reworked for Qt 4.5 and may be broken. I've fallen back to 4.4.3 as a workaround to my current problem.

( http://www.qtcentre.org/forum/f-qt-programming-2/t-qt-451-mysql-51-qsqlquerylasterror-1295-22654-post110382.html#post110382 )

Good luck,