> > after upgrading my DBD::ODBC to v0.43, i experienced problems > with INSERT > statements: > > dbd_error: SQL-22003 (native 0): [Microsoft][ODBC SQL Server > Driver]Numeric value out of range (SQL-22003) > > the statement had worked in the past with v0.28. after much > gnashing of teeth, i figured out i could set default back to > 1 with the connection handle $dbh. the trace is attached.
Andy, It looks like you are passing '1.000' as the numeric value and the bind_type is what told SQLServer that it had to convert the string to a number. The other way to make it work is to bind 1.0 instead of '1.0' Regards, Jeff
