elektritter
14th May 2009, 08:58
Hi,
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)
bye
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)
bye