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