MySQL Forums
Forum List  »  Connector/ODBC

Advanced Search
New Topic

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".

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MYSQL ODBC 8.0.13 does not show all the query records of a linked view mysql + access
Cesar Pinto
December 02, 2018 06:38PM
Re: MYSQL ODBC 8.0.13 does not show all the query records of a linked view mysql + access
Bogdan Degtyariov
January 10, 2019 02:52AM
Re: MYSQL ODBC 8.0.13 does not show all the query records of a linked view mysql + access
JuCePi .
January 24, 2019 10:06PM
Re: MYSQL ODBC 8.0.13 does not show all the query records of a linked view mysql + access
Bogdan Degtyariov
February 03, 2019 11:27PM


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.