Hi,
This is the first time I am trying to use DBI module.
When I try to connect to mysql db, I get the below error.
============================================================
Error :
Uncaught exception from user code:
install_driver(mysql) failed: Can't locate loadable object for module DB
D::mysql in @INC (@INC contains: C:/Perl/site/lib C:/Perl/lib .) at (eval 6)
lin
e 3
Compilation failed in require at (eval 6) line 3.
Perhaps a module that DBD::mysql requires hasn't been fully installed
at genTables.pl line 13
at C:/Perl/lib/DBI.pm line 756
DBI::install_driver('DBI', 'mysql') called at C:/Perl/lib/DBI.pm line 60
0
DBI::connect('DBI', 'dbi:mysql:database=test:host=localhost;mysql_emulat
ed_prepare=0', 'root', '', 'HASH(0x226f48)') called at genTables.pl line 13
==========================================================================
I have installed the mysql.pm, by doing the following :
- downloaded the DBD-mysql-4.005.tar and copied the contents of lib to
my C:\perl\lib.
When I ran this program I can see my reference to mysql.
---------------------------------------------------
print "Here's a list of DBI drivers:\n";
my @available_drivers = DBI->available_drivers('quiet');
my $driver;
foreach $driver (@available_drivers)
{
print "$driver\n";
}
--------------------------------------------------------
#Actual program to connect to db
use strict ;
use warnings ;
use DBI ;
use diagnostics ;
#my $dbh = DBI->connect('DBI:mysql:cookbook') ;
my $dbh = DBI->connect (
"dbi:mysql:database=test:host=localhost;mysql_emulated_prepare=0",
"root", "",
{ RaiseError => 1, PrintError => 0 },
);
$dbh->disconnect ;
--------------------------------------------------------------------
Not sure what's wrong.
Regards,
Alok
____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the
tools to get online.
http://smallbusiness.yahoo.com/webhosting
