Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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

Published:

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

For an optimal Community experience, Please view on Desktop