MySQL Forums
Forum List  »  Connector/ODBC

Re: MYSQL ODBC 8.0.13 does not show all the query records of a linked view mysql + access
Posted by: Bogdan Degtyariov
Date: January 10, 2019 02:52AM

Hi Cesar,

Is the number of rows for previous years (2017, 2016, 2015) about the same as for 2018? Or the previous years are displayed correctly because the number of rows in the result is less than 700?

One thing that you should check is the prefeth parameter in ODBC.
Open the ODBC GUI dialog and check if the prefetch is set in:

Details >> Cursors/Results >> Prefetch from server by [xxx] rows at a time.

If this option is checked, try disabling it (uncheck).

Another thing to try is checking "[x] Force using of forward-only cursors".

Options: ReplyQuote


Subject
Written By
Posted
Re: MYSQL ODBC 8.0.13 does not show all the query records of a linked view mysql + access
January 10, 2019 02:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.