Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

Error: 'Arithmetic operation resulted in an overflow' with MySQL database


Issue:

When using 64-bit Jet Essentials to retrieve data from a MySQL database, it is possible for the database to return the error "Arithmetic operation resulted in an overflow."


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/)




Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments