HI Victor, from time to time we also get this error-message. We don't know when and why it occurs, we can't reproduce it. But restarting the cfserver solves it ..... until next time ;-)
nicole ----- Original Message ----- From: Victor van Hassel To: Spectra-Talk Sent: Tuesday, October 23, 2001 10:26 AM Subject: ODBC error 22003 (Numeric value out of range) Since two days one of our spectra applications generates the following error message on creating a new object. ODBC Error Code = 22003 (Numeric value out of range) [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting float to data type numeric. SQL = "insert into objects ( active,archived,attribs,createdby,datetimecreated,datetimelastupdated,lab el,lastupdatedby,lockedby,objectid,published,typeid ) values ( ? , ? , ? , ? , ? , ? , ? , ? , null , ? , ? , ? )" Query Parameter Value(s) - Parameter #1 = 0 Parameter #2 = 0 Parameter #3 = 0 Parameter #4 = bibadmin Parameter #5 = 37187.9174074 Parameter #6 = 37187.9174074 Parameter #7 = new Parameter #8 = bibadmin Parameter #9 = 98DDE424-840E-4F15-95CC6080758A098B Parameter #10 = 0 Parameter #11 = 9FF02F2E-45FD-11D4-A8310050DA513E37 We are usign CF 4.5, Spectra 1.01, SQL-Server 7.0 and Win2000 sp1. The language settings are English(US) in Win2000. Any suggestions? Cheers, Victor ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
