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.
The solution is to use version 3.51 of the driver instead of using the 5.1 version