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.
<<image001.gif>>
