Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
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