Skip to main content

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

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

Overflow_Error.png

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

Was this article helpful?

We're sorry to hear that.