Okay, I had a problem with MySQL 5 query's in combination using Plesk 8.1 and MySQL 5. I want to share the solution with you, and maby SWsoft can als fix this problem in the next release.
The Problem:
A normal simple query like:
select * from table; does not work.
The workaround:
Modify your query to:
select id, name, date from table; does work well.
The solution:
After a search on the mysql bug report site, I found this is a known problem.
In the Plesk 8.1 installation package there is the MySQL 3.51.11 driver shipped. This is a wrong driver in combination of MySQL 5. To have this problem fixed download (http://dev.mysql.com/downloads/connector/odbc/3.51.html) the latest one, 3.51.12 driver. Al problem are gone.
The Problem:
A normal simple query like:
select * from table; does not work.
The workaround:
Modify your query to:
select id, name, date from table; does work well.
The solution:
After a search on the mysql bug report site, I found this is a known problem.
In the Plesk 8.1 installation package there is the MySQL 3.51.11 driver shipped. This is a wrong driver in combination of MySQL 5. To have this problem fixed download (http://dev.mysql.com/downloads/connector/odbc/3.51.html) the latest one, 3.51.12 driver. Al problem are gone.