Hi perl greats,
When i try to connect the mysql database, i am getting the error message:
install_driver(mysql) failed: Can't locate loadable object for module
+DBD::mysql in @INC (@INC contains: C:/Perl/site/lib C:/Perl/lib .) at
+ (eval 4) line 3
Compilation failed in require at (eval 4) line 3.
Perhaps a module that DBD::mysql requires hasn't been fully installed
Could anyone tell me what are all the possiblities for this error?
I tried the following to install the perl module.
My operating system is Windows.
ppm install DBI::mysql
when i run the above command it is telling me as
no missing packages to install.
The code is:
use strict;
use warnings;
use DBI;
my $dbname="test_development";
my $dbh=DBI->connect("DBI:mysql:$dbname","root") || die("connection fa
+ilure");
my $sth=$dbh->prepare("select * from tables");
$sth->execute();
while(my @row=$sth->fetchrow_array()){
print "id".$row[0];
print "name".$row[1];
print "age".$row[2];
}
How should i proceed with the above issue? any thoughts or ideas will be of much helpful in this juncture.