Error: "Arithmetic overflow error converting numeric to data type numeric."

[Nthing]

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?

[Imtiyaz]

Please check what are the data types involved, and what are the amounts involved?

[Jason Bourne]

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 .

[Nthing]

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