MySQL Bugs: #97851: MS Access timeout using ODBC

Bug #97851	MS Access timeout using ODBC
Submitted:	2 Dec 2019 16:15	Modified:	3 Dec 2019 11:31
Reporter:	Pablo Hijano	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	8.0.15	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Hi everybody,
I'm using MS Access as frontend (in Windows), MySQL Server as DB (in RedHat) and ODBC to connect both.
I use linked tables in Access.

I have a huge table and always I try to get it, throw an exception:
"ODBC--call failed.
[MySQL][ODBC 8.0 (w) Driver][mysqld-8.0.16] Query execution was interrupted, maximum statement execution time exceeded (#3024)." (Always at 60 seconds)

I've tried everything. I can't find anything which can help me in the documentation or looking online.

I read post from years ago which mention to use "readtimeout or MYSQL_OPT_READ_TIMEOUT" in the registry editor (regedit.exe) and nothing. In the documentation appear that this option are not available since version 5.1.12.

I have no idea what can I do to delete or increase the timeout. Help!

Versions:
MySQL Server: 8.0.16 (Running on RedHat 7.5)
MS Access 365 (Running on Windows 10)
MySQL ODBC 8.0.15

How to repeat:
Install Access, ODBC, and try to get a huge table.

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.

Where can I get on this problem then... ?

get help*