Hi kalaisuresh,

Are you running the script in terminal and as cgi in the same system? If not, did you installed DBI using CPAN or your package system, or did you copy some perl modules that you needed, as DBI (by ftp, for instance)?

Did you verify that your @INC have the same values in the terminal and when runned as cgi?

Try this script, run it in the terminal and as a cgi and compare the output from both runs: 
#!/usr/bin/perl

use strict;

print "Content-type: text/plain\n\n";
print join "\n", @INC,"\n";

[download]
Hope this help you find your problem.

TheMage
http://themage.bliker.com

In reply to Re: error in perl with mysql by themage
in thread error in perl with mysql by kalaisuresh

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.