On Saturday 11 September 2004 3:19 pm, Darren Duncan wrote:
> Just now I installed the newest versions of DBD::SQLite v1.05 (3.06)
> and DBD::SQLite2 v0.33 (2.8.15). They both tested and installed with
> no problems, along with DBI v1.43 and Perl v5.8.5, all using GCC 3.3
> on Mac OS X 10.2.8.
>
> However, this SQLite v2 and SQLite v3 can not be used simultaneously
> as they have symbol conflicts.
I'm not seeing any such problem here. The following code works
perfectly with DBD::SQLite2 v0.33 and DBD::SQLite v1.05.
-----
use DBI;
my $dbh = DBI->connect('dbi:SQLite2:dbname=popfile2.db','','') || die
$dbh->er
rstr;
my $dbh1 = DBI->connect('dbi:SQLite:dbname=popfile.db','','') || die
$dbh1->er
rstr;
my $sth=$dbh->prepare('select * from words limit 5;') || die $dbh->errstr;
$sth->execute() || die $dbh->errstr;
while (my $row = $sth->fetchrow_arrayref) {
print $row->[0] . "\n";
}
$sth->finish();
$sth=$dbh1->prepare('select * from words limit 5;') || die $dbh1->errstr;
$sth->execute() || die $dbh1->errstr;
while (my $row = $sth->fetchrow_arrayref) {
print $row->[0] . "\n";
}
$sth->finish();
$dbh->disconnect;
$dbh1->disconnect;
------
No errors, no problems.
>
> Matt, please publish a newer DBD::SQLite as soon as you can get the
> pair to pass the following simple test without errors: "use
> DBD::SQLite2; use DBD::SQLite;"; that's also a good test for any
> subsequent releases.
You don't 'use' the DBD modules, you use DBI; and it handles loading
of the modules specified in the connect.
Scott
--
POPFile, the OpenSource EMail Classifier
http://popfile.sourceforge.net/
Linux 2.6.5-7.108-default x86_64
