Oracle: Arithmetic operation resulted in an overflow

Shoot now I recall that I have seen this before. The Oracle client is 32-bit only. And so my .NET app needs to be x86 compiled. So annoying! And the message is so deceptive.


http://blogs.msdn.com/b/mariae/archive/2012/07/05/quot-arithmetic-operation-resulted-in-an-overflow-quot-error-running-a-report-that-uses-a-connection-data-source-to-oracle-10.aspx

bug in the Oracle ODBC driver. It affects the versions: 10.2.0.4 to 11.2.0.1 of Oracle and only the 64 bit driver (not the 32 bit driver).

Edit (Jan 2022): link from MSDN went dead. Here's a link to the Oracle page: https://support.oracle.com/knowledge/Oracle%20Database%20Products/1181253_1.html