Getting data from MySQL using ODBC

[am65]

I need to copy a table from MySQL to Oracle. So I set up an ODBC datasource in windows pointing to the MySQL server. Everything works fine but the resultset returns only one row.

SELECT * FROM ACCOUNTS ---> only returns one row
SELECT COUNT(*) FROM ACCOUNTS ---> returns only one row with the value 798

If I perform the same query in Excel (with Microsoft Query using the same ODBC connection) it returns all the rows. So it seems a problem of Data Manager.

But I have no idea what could it be.

[am65]

The solution is to use version 3.51 of the driver instead of using the 5.1 version