Problems retrieving 60 or more records with ODBC MySQL / ADO
Posted on 2003-11-12
Everytime i try to make i simple program with VB and MySQL, everything ends up with the same problem. I can´t get more than 60 records from the database!
I have a ADO Control, all values 'standard'
The connection works fine.
I can use recordsource´s like 'select * from customers where cust_ID = 59' without any problems
I can also use for example 'select * from customers' without any errors.
The problems begins when i trying to step trough the recordset.
for x = 1 to 100
this returns 'Data provider or other service returned an E_FAIL status.'
but only when x>59
I hope this is a basic problem you all know how to solve, if not
i can publish all of the source code.
Btw, I also tried use paging, but it ends up with the same problem.
Ex. pages of 20 records ,returns error at the last record in page 3.