|
Posted by blaine@worldweb.com on February 11, 2008, 12:52 pm
Please log in for more thread options On Feb 11, 10:25 am, Mark Clements
> alx_...@hotmail.com wrote:
> > Hello. Using the following test code:
>
> > #!/usr/bin/perl
>
> > use DBI;
>
> > $db_handle = DBI-
> >> connect("dbi:mysql:database=mysql;host=x.x.x.x;user=x;password=x")
> > 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";
>
> > $statement->execute()
> > or die "Couldn't execute query '$sql': $DBI::errstr\n";
> > while ($row_ref = $statement->fetchrow_hashref())
> > {
> > print FILEHANDLE "$row_ref->\n";
> > }
>
> > close(FILEHANDLE);
> > $db_handle->dis
> > connect();
>
> > ... I get the following 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, ODBC, Proxy, SQLite,
> > Sponge.
> > 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
> > wrong?
>
> 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
>
> Mark
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.
| 
XML Sitemap