DBD-mysql - Can't locate loadable object error - can't use Perl to connect to MySQL

Posted on Sun Jul 6 07:42:27 2008 by inthefog
Can't locate loadable object error - can't use Perl to connect to MySQL
When I try to run a .pl script to select from a mysql database, it fails on line 3 - use DBI; with the message install_drive<mysql> failed: Can't locate loadable object for 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. I got from Perl from Activestate but it did not come with DBD::mysql. I downloaded DBD-mysql-4.007 to C:/Users/OEM/Documents/DBDMySQL/DBD-mysql-4.007 and read file:///C:/Users/OEM/Documents/DBDMySQL/DBD-mysql-4.007/INSTALL.html I tried >ppm install DBD-mysql as per the above INSTALL instruction but got error "can't find any package that provides dbd-mysql" I tried >ppm install DBD::mysql but that just got me a package called informationschema I tried cpan> install DBD::mysql but that did not seem to complete. I then copied mysql.pm from the DBD-mysql-4.007 download to the C:\perl\lib\dbd directory which gave me some progress as the error I was getting before I did this was........ install_drive<mysql> failed: Can't locate DBD::mysql in @inc I guess there are other components I need in the perl path. I tried to find out how to adjust @inc but failed. Hopefully someone can help me???? Thank you
Write a response