Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 11-06-2009
Member
 
Join Date: Jun 2009
Posts: 5
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?
Reply With Quote
  #2  
Old 11-06-2009
Member
 
Join Date: Jan 2009
Posts: 44
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?
Reply With Quote
  #3  
Old 11-06-2009
Member
 
Join Date: Jan 2009
Posts: 39
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 .
Reply With Quote
  #4  
Old 11-06-2009
Member
 
Join Date: Jun 2009
Posts: 5
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
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Error: "Arithmetic overflow error converting numeric to data type numeric.""
Thread Thread Starter Forum Replies Last Post
OS X ML Error: "The error occurred while processing a command of type 'setState' in plug-in 'servermgr_netboot'." SravanK Networking & Security 2 11-08-2012 06:51 PM
Getting error message "Drive is Not Accessible: Data Error (Cyclic Redundancy Check)" for Western Digital Caviar Green 1 TB Sha-kaal Hardware Peripherals 5 26-02-2012 03:16 PM
Getting error that "specified dimension is not valid for the current chart type" on Excel RYAN$ MS Office Support 2 17-01-2012 01:21 PM
InDesign CS3 Numeric Keypad Error? - Please HELP MadhaviS Windows Software 6 10-07-2010 12:16 AM
Converting Numeric value to Word with the Help of Sql Server 2000 Joyjeet Software Development 3 20-11-2009 10:01 AM


All times are GMT +5.5. The time now is 01:20 PM.