Hi
I am trying to connect to the mysql but it is giving erorr like this:
Can't locate object method "connect" via package "Net::MySQL"
My code is as follows can anybody help me to solve this problem?
#!/usr/local/bin/perl
print "Content-type:text/html\n\n";
use Net::MySQL;
$DBHOST = "localhost";
$DBNAME = "SiteBuilder";
$DBUSER = "sa";
$DBPASS = "";
my $mysql= Net::MySQL->connect($DBHOST, $DBNAME, $DBUSER, $DBPASS);
$mysql->query(q{SELECT sLoginId,sFirstName,sLastName FROM userdetail});
my $record_set = $mysql->create_record_iterator;
while (my $record = $record_set->each) {
printf "First column: %s Next column: %s\n",
$record->[0], $record->[1],$record->[2];
}
$mysql->close;
I have tried DBI package also but it is showing same error.
Thanks in advance!
Pankaj.