Windows XP ActivePerl 5.10 MySQL database connectivity

Dear colleagues,

I am running ActivePerl v5.10 on Windows XP Pro. I have been trying to connect to MySQL v5 with no success.  I have been getting the following error:

-----------
perl dbconnect3.pl
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
 at dbconnect3.pl line 5
-------------

Below is the script: dbconnect3.pl
-----
#!/usr/bin/perl -w
use DBI;
my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost", "root", "pwd", {'RaiseError' => 1});
-----

I have successfully installed the DBI module (DBI-1.602) which I have downloaded from the internet.  I have also downloaded the DBD module (DBD-mysql-4.006) from the internet.  However when I tried to installed the dbd module, I got the a message that the package was up-to-date.

The problem is that, I can't seem to figure out why the dbd::mysql driver cannot be loaded.  I have spent some considerable time on the problem so if anyone can help, I will be grateful.

Many thanks in advance.

Richard Koudry

Start Free Trial