perl module DBI:mysql installation issues

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

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
[download]

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
[download]

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];
}
[download]

How should i proceed with the above issue? any thoughts or ideas will be of much helpful in this juncture.

Comment on perl module DBI:mysql installation issues Select or Download Code

Replies are listed 'Best First'.
Re: perl module DBI:mysql installation issues by moritz (Cardinal) on Jul 07, 2008 at 11:08 UTC
You need to install DBD::mysql, not `DBI::mysql`. The latter doesn't exist. Update: looks like a broken module installation. What's the output of `perl -MDBD::mysql -e1` ? How did you install DBD::mysql in the first place?	[reply] [d/l] [select]
Re^2: perl module DBI:mysql installation issues by Anonymous Monk on Jul 07, 2008 at 11:25 UTC
Hi, I installed DBD:mysql only not DBI:mysql. sorry it's typographic error.	[reply]
Re^2: perl module DBI:mysql installation issues by valavanp (Curate) on Jul 08, 2008 at 04:51 UTC
Hi, Thanks for your reply. I tried the following and getting the error messages. `c:\>ppm remove DBD::mysql ppm remove failed: 'ppm remove DBD-mysql-informationschema' will unist +all package providing DBD::mysql c:\>ppm install DBD::mysql No missing packages to install c:\>perl -MDBD::mysql -el can't locate loadable object for module DBD::mysql in @INC<@INC contai +ns: c:/perl/site/lib c:/perl/lib.) at -e line 0 compilation failed in require. BEGIN failed compilation aborted .` [download] Could you please help me out to solve the above issue. Thanks	[reply] [d/l]
Re: perl module DBI:mysql installation issues by syphilis (Archbishop) on Jul 07, 2008 at 12:42 UTC
As moritz has noted, it's probably a botched install. First of all remove your existing DBD::mysql installation. (Running `ppm remove DBD::mysql` might achieve that.) Then, once you've got rid of that botched installation, try running `ppm install DBD::mysql` again. Cheers, Rob	[reply] [d/l] [select]