If you are using DBI, you can insert the following statement for debugging: 
DBI->trace(3, "trace.txt");

[download]
trace.txt is a file that is opened in append mode for DBI to write to. The number is the level of trace you desire: 
  0 - Trace disabled.
  1 - Trace DBI method calls returning with results or errors.
  2 - Trace method entry with parameters and returning with results.
  3 - As above, adding some high-level information from the driver and
+ some internal information from the DBI.
  4 - As above, adding more detailed information from the driver. Also
+ includes DBI mutex information when using threaded Perl.
  5 - As above but with more and more obscure information.

[download]
I personally find that trace level 3 gives me all of the information that I need. It produces a lot of output that can take a while to wade through, but I almost always find "tough to track down" errors that way.

Cheers,
Ovid

Join the Perlmonks Setiathome Group or just go the the link and check out our stats.

In reply to (Ovid - debugging DBI) RE: Silencing the grumbling from DBD::ODBC by Ovid
in thread Silencing the grumbling from DBD::ODBC by nop

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.