Arithmetic overflow error converting numeric to data type numeric."

• ashutosh-557286

  Grasshopper

  Points: 17

  More actions

  November 20, 2007 at 10:45 pm

  #71008

  Hello ,

  I am using SQL Server 2000 & VS 2005 . I am retrieving some data with simple one line query with reader as object.

  After All initial declaration of reader and executing the reader

  I have written

  sreader.read where sreader is the object of sqldatareader.

  I am getting an exception "Arithmetic overflow error converting numeric to data type numeric."

  Any idea what should I do to remove this exception. My datatype for sql table in varchar and size is 50 .

  Any help is appreciated.

  Ash

• K. Brian Kelley

  SSC Guru

  Points: 114704

  More actions

  November 24, 2007 at 8:34 pm

  #753790

  Can you post the query (remove or change any sensitive information)?

  K. Brian Kelley
  @kbriankelley