DBI problems

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Hello.  Using the following test code:


use DBI;

$db_handle = DBI-
Quoted text here. Click to load it
         or die "Couldn't connect to database: $DBI::errstr\n";

//I've edited out some data there obviously

open(FILEHANDLE, ">", "C:\test.txt") || die('cannot open file: ' .

$sql = "SELECT * FROM hhdb2.handhelds";
$statement = $db_handle->prepare($sql)
         or die "Couldn't prepare query '$sql': $DBI::errstr\n";

or die "Couldn't execute query '$sql': $DBI::errstr\n";
while ($row_ref = $statement->fetchrow_hashref())
      print FILEHANDLE "$row_ref->\n";


... I get the following error:

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC
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, ODBC, Proxy, SQLite,
 at Z:\changelist\dbtest2.pl line 5

I'm sure that DBI is installed (ppm says so) and I've read repeatedly
that this should be able to use a mysql database.  What has gone

I would appreciate any help.

Re: DBI problems

alx__21@hotmail.com wrote:
Quoted text here. Click to load it

You need to install DBD::mysql. Your paths indicate you're on windows so
I'll assume you're using ActiveState:

ppm install DBD-mysql    


Re: DBI problems

On Feb 11, 10:25 am, Mark Clements
Quoted text here. Click to load it

If the above command does not work then you will need to use an older
PPM repository.
Http://cpan.uwinnipeg.ca/PPMPackages/10xx/package.xml WILL contact the
package your looking for.

Re: DBI problems

This does not appear to exist.  I can't find it under the ppm either.
What does exist is: dbd-mysql-informationschema, dbd-mysql-
SimpleMySQL, and dbd-mysqlPP.  I don't think any of these are what I'm
looking for.

Re: DBI problems

Being kinda new to this it took me a while to figure out what to do
with your XML file, but now I've got the repository added to ppm and
the proper file is downloading.

Thanks Blaine.

Site Timeline