Error: "Arithmetic overflow error converting numeric to data type numeric."
Hi,
I got the following error.
Arithmetic overflow error converting numeric to data type numeric.
I got this error while I was moving to SQL server 2000 to 2005. The error i got is for a single database & not for others so I dont think its regarding this up gradation.
Do you have experienced such error before?
Re: Error: "Arithmetic overflow error converting numeric to data type numeric."
Please check what are the data types involved, and what are the amounts involved?
Re: Error: "Arithmetic overflow error converting numeric to data type numeric."
Arithmetic overflow error converting numeric to data type numeric.
I think the problem is in the sql select statement used in OleDbAdapter OR you are passing wrong parameter .
Re: Error: "Arithmetic overflow error converting numeric to data type numeric."
Solved!
Decimal(5,3) does not alows a value greater that 99.999 but decimal(7,3) solves my issue and i can then store 9999.999