http://qs321.pair.com?node_id=837223


in reply to Re: Invalid Precision error
in thread Invalid Precision error

DBD::ODBC::st execute failed: MicrosoftODBC SQL Server DriverInvalid precisi on value (SQL-HY104) at ODBC_error.pl line 119. Issuing rollback() due to DESTROY without explicit disconnect() of DBD::ODBC::db handle NaviStor_s7200_IndiaCOE at ODBC_error.pl line 119.

This is the error

Replies are listed 'Best First'.
Re^3: Invalid Precision error
by GrandFather (Saint) on Apr 28, 2010 at 05:48 UTC

    So it is a data base error. You need to examine the SQL and values that you used at the point that you get the error then clean up the data you are feeding to the data base.

    True laziness is hard work
[reply]
Re^3: Invalid Precision error
by mje (Curate) on Apr 28, 2010 at 10:19 UTC

    I bet it is a problem with one of your dates. Show us the SQL and any parameters at error time. You can do this with Statement and ParamValues and ParamTypes.

[reply]

In Section Seekers of Perl Wisdom