Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^2: Invalid Precision error

by Bheema_Tyco (Novice)
on Apr 28, 2010 at 05:17 UTC ( [id://837223]=note: print w/replies, xml ) Need Help??


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
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://837223]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (2)
As of 2024-04-16 23:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found