errror while installing DBD::MYSQL.
- From: perlpra@xxxxxxxxx (Siva Prasad)
- Date: Wed, 31 Oct 2007 19:54:12 +0530
Hi Gurus,
I have installed DBI and when I run the following perl script;
------SCRIPT
use strict;
use warnings;
use DBI;
my $DSN="DBI:mysql:database=faculte;host=localhost;port=3306";
my $DB_OBJ=DBI->connect($DSN, "root", "sqlroot123");
#my @dr=DBI->installed_drivers;
#print "@dr\n";
my $sql="select * from fac_class";
$DB_OBJ->prepare($sql);
my $data=$DB_OBJ->execute($sql);
print "$data\n";
--SCRIPT.
I got the below error.
----------------------------------------------------------------------------
-----------------------------------------------------
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
contains:
C:/Perl/site/lib C:/Perl/lib .) at (eval 4) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, SQLite, Sponge.
at db_interac.pl line 7
so I downloaded perl DBD::MYSQL and tried installing the module with no
luck.
I used the following command to run the MAKEFile.pl on windows
perl makefile.pl --cflags=-IC:\"Program Files"\MySQL\MySQL Server
5.0\include
The above paths are correct.
I got the following error.
----------------------------------------------------------------------------
--------------------------------
Failed to determine directory of mysqlclient.lib. Use
perl Makefile.PL "--libs=-L<dir> -lmysqlclient -lz -lm -lcrypt -lnsl"
to set this directory. For details see the INSTALL.html file,
section "Linker flags" or type
perl Makefile.PL --help
I tried to run the mysql_config -cflags with no luck got the below error
'mysql_config' is not recognized as an internal or external command,
operable program or batch file.
Can anybody help me to resolve the abov problem.
- Follow-Ups:
- Re: errror while installing DBD::MYSQL.
- From: Tom Phoenix
- Re: errror while installing DBD::MYSQL.
- Prev by Date: Re: impatient DBI query
- Next by Date: Re: errror while installing DBD::MYSQL.
- Previous by thread: Getting error in Net::SFTP with get function
- Next by thread: Re: errror while installing DBD::MYSQL.
- Index(es):
Relevant Pages
|
