Issue:
When using 64-bit Jet Reports to retrieve data from a MySQL database, it is possible for the database to return the error "Arithmetic operation resulted in an overflow."
Except text from error message is:
An unexpected error has occurred:
Arithmetic operation resulted in an overflow.
System.OverflowException
Cause:
This error results because of an issue in older versions of MySQL's ODBC connector (version 5.1.6 or earlier).
Resolution
Upgrading the computer system's MySQL ODBC connector to version 5.3.4 or later should resolve this issue and allow the database to return the requested data.
This connector can be obtained from the MySQL Downloads page (https://dev.mysql.com/downloads/connector/odbc/)
Comments