Hi,
I have perl 5.6.1 and mysql 5.0.24 installed and the following perl script
works fine from command line, but not working when I run from the IE browser:
#!/usr/local/bin/perl
use DBI;
use CGI qw(:standard);
use CGI::Carp 'fatalsToBrowser';
use strict;
print header;
print start_html;
my $docID;
my $docfile = "test.doc";
my $docdesc = "this is test";
my $last_update;
my $dbh = DBI->connect("dbi:mysql:dbname", "username", "password" )
or &dienice("Can't connect to database: $DBI::errstr");
my $sth = $dbh->prepare("insert into test_tbl values(?,?,?,?)") or &dbdie;
$sth->execute($docID, $last_update, $docfile, $docdesc) or &dbdie;
print end_html;
and here is the error i got from browser after ran it:
Software error:
install_driver(mysql) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/mysql/mysql.so' for
module DBD::mysql: ld.so.1: perl: fatal: libmysqlclient.so.15: open failed: No
such file or directory at /usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm
line 206. at (eval 10) line 3 Compilation failed in require at (eval 10)
line 3. Perhaps a required shared library or dll isn't installed where
expected at /usr/local/apache2/cgi-bin/testdb.pl line 15
Thanks all for your help!
---------------------------------
Any questions? Get answers on any topic at Yahoo! Answers. Try it now.