>I'm testing CursorAdaptors for my MySQL database using an ODBC connection. For some reason, everything works fine until the returned cursor is > 99 records - then I get no cursor at all; I also get no errors and the CursorFill() result is .T. BTW, the ConnectionTimeOut is 600.
>
>This occurs whether the query is run on the server or a workstation and I've verified the query in the MySQL Query Browser. These are local cursors, so CURSORSETPROP()'s FetchSize and MaxRecords don't apply.
>
>Anyone have an idea what might be causing this?
>
>Thanks,
>Ken
I think the problem is in your cursor's query SQL and base table in mySQL. It looks like you have a query that would work right with the first 99.
I use CA against SQL server and I don't have any problems loading even hundreds of thousands records. I would never expect mySQL would have a problem with that.
PS: I don't understand what you mean by "These are local cursors, so CURSORSETPROP()'s FetchSize and MaxRecords don't apply.". If they are local cursors then how come you are querying them via mySQL ODBC driver?
Cetin