sqlEx = {"Error converting data type numeric to numeric."}

microsoft.public.dotnet.framework.adonet

16 Feb 2006 3:53 PM

rajmgopal

Hello Everyone
I am getting the following error when i try to insert a record into Sql
Server 2005 from my VB 2005 application.

sqlEx = {"Error converting data type numeric to numeric."}

I checked for possible overflow exception, but did not encounter any.

I have declared the values that i am trying to insert as DECIMAL data
types in my VB code.

The problem occurs when the decimal value has 6 digits before the
decimal.

The precision for the column has been specified as 20 and scale as 2.

I used in-place editing available in VS 2005 to change the value to 5
digits before the decimal and it let me insert the record.

I also used the same values to try inserting directly via a sql query
and it worked.

Any suggestions will be greatly appreciated.

Thank you
Raj