 | | | errror while installing DBD::MYSQL. | errror while installing DBD::MYSQL. 2007-11-12 - By Siva Prasad
Back
Hi All,
I don't know whether it is correct group or not. Just a hope that I may get
solution.
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 @(protected)=DBI->installed_drivers;
#print "@(protected)\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 @(protected) (@(protected)
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|