sql server error "[Microsoft][ODBC SQL Server Driver]Numeric value out of range"

Jul 9, 2010 at 3:43 PM

When I use the testredirect.jsp, I get a page with the "Authenticated" line that displays the Live ID, then the error above on the next line.

My research for that error statement yields the possibility of a datatype error or a legitimate field length error.  When I check the table construction, there doesn't seem to be a problem with either.  In fact, the data has been written into the table just fine.

Any idea what can be causing this error and how to fix it?




Jul 12, 2010 at 3:28 PM

Made it work by changing datatype of SSOID in Tables and Queries to nvarchar22 from uniqueidentifier. "Size" of uniqueIdentifier is only 16, which was hampering process.



Jul 12, 2010 at 3:29 PM

OOPS! That's "255" in varchar, not "22" as I typoed above.