1.5.19: Perl DBD::SQLite error loading dll

[Reid Thompson]

Anyone have any pointers to remedying this issue?

$ ./perlSqlite2.pl
install_driver(SQLite) failed: Can't load 
'/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBD/SQLite/SQLite.dll' for 
module DBD::SQLite: No such file or directory at 
/usr/lib/perl5/5.8/cygwin/DynaLoader.pm line 230.
 at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at ./perlSqlite2.pl line 5

WS-XP-4960: /home/rthompso>
$ ls -rlt /usr/lib/perl5/site_perl/5.8/cygwin/auto/DBD/SQLite/SQLite.dll 
/usr/lib/perl5/5.8/cygwin/DynaLoader.pm
-rwxr-x---+ 1 Reid.Thompson Users        28128 Dec 29 22:04 
/usr/lib/perl5/5.8/cygwin/DynaLoader.pm
-r-xr-xr-x  1 Reid.Thompson Domain Users 66048 Jan 19 10:31 
/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBD/SQLite/SQLite.dll

WS-XP-4960: /home/rthompso>
$ cat ./perlSqlite2.pl
#!/bin/perl -w

use DBI;

$dbh = DBI->connect( "dbi:SQLite:data.dbl" ) || die "Cannot connect: 
$DBI::errstr";


$dbh->do( "CREATE TABLE authors ( lastname, firstname )" );
$dbh->do( "INSERT INTO authors VALUES ( 'Conway', 'Damian' ) " );
$dbh->do( "INSERT INTO authors VALUES ( 'Booch', 'Grady' ) " );

$dbh->do( "CREATE TABLE books ( title, author )" );
$dbh->do( "INSERT INTO books VALUES ( 'Object Oriented Perl',
                                          'Conway' ) " );
$dbh->do( "INSERT INTO books VALUES ( 'Object-Oriented Analysis and Design',
                                          'Booch' ) ");
$dbh->do( "INSERT INTO books VALUES ( 'Object Solutions', 'Booch' ) " );


$res = $dbh->selectall_arrayref( q( SELECT a.lastname, a.firstname, b.title
                    FROM books b, authors a
                    WHERE b.title like '%Orient%'
                    AND a.lastname = b.author ) );

foreach( @$res ) {
  print "$_->[0], $_->[1]:\t$_->[2]\n";
}

$dbh->disconnect;

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: cygcheck.out
URL: <http://cygwin.com/pipermail/cygwin/attachments/20060119/fdedb6fa/attachment.ksh>
-------------- next part --------------
--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/