On Dec 4, 2007 11:02 PM, Mark Easton <[EMAIL PROTECTED]> wrote:
> Sorry, but how do I check the version of DBD::SQLite I have installed? Perl
> is not my thing. When I look in the Perl code I can see DBIx::SimplePerl
> commands. I ran the scipt below but it did not show any installed modules.
Use cpan. As you can see below, I have DBD::SQLite version 1.14
installed. That uses SQLite 3.4.2 (you can check the change log on
CPAN).
$ cpan
CPAN: File::HomeDir loaded ok (v0.58)
cpan shell -- CPAN exploration and modules installation (v1.9205)
ReadLine support enabled
cpan[1]> i DBD::SQLite
CPAN: Storable loaded ok (v2.15)
Going to read /Users/punkish/.cpan/Metadata
Database was generated on Tue, 04 Dec 2007 23:37:19 GMT
Strange distribution name [DBD::SQLite]
Module id = DBD::SQLite
CPAN_USERID MSERGEANT (MSERGEANT <[EMAIL PROTECTED]>)
CPAN_VERSION 1.14
CPAN_FILE M/MS/MSERGEANT/DBD-SQLite-1.14.tar.gz
UPLOAD_DATE 2007-09-19
MANPAGE DBD::SQLite - Self Contained RDBMS in a DBI Driver
INST_FILE
/usr/local/lib/perl5/site_perl/5.8.8/darwin-2level/DBD/SQLite.pm
INST_VERSION 1.14
cpan[2]>
>
> "#!/usr/bin/perl
>
> use CPAN;
>
> printf("%-20s %10s %10s\n", "Module", "Installed", "CPAN");
>
> foreach $a (@ARGV) {
> foreach $mod (CPAN::Shell->expand("Module", $a)){
> printf("%-20s %10s %10s %s\n",
> $mod->id,
> $mod->inst_version eq "undef" || !defined($mod->inst_version)
> ? "-" : $mod->inst_version,
> $mod->cpan_version eq "undef" || !defined($mod->cpan_version)
> ? "-" : $mod->cpan_version,
> $mod->uptodate ? "" : "*"
> );
> }
> }"
>
>
>
> Thanks
>
>
>
> > -----Original Message-----
> > From: P Kishor [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, 5 December 2007 5:44 p.m.
> > To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
> > Subject: Re: [sqlite] File Is Encrypted Or Is Not a Database
> >
> > On 12/4/07, Mark Easton <[EMAIL PROTECTED]> wrote:
> > > I have also tried v 3.5.3 now and still cannot open the database. I
> > > guess I need the right version of sqlite3 so that I can dump to sql
> > > and then I can rebuild in a newer version. But how do I
> > find our what
> > > version of sqlite I need?
> > >
> > >
> > > > -----Original Message-----
> > > > From: Mark Easton [mailto:[EMAIL PROTECTED]
> > > > Sent: Wednesday, 5 December 2007 3:58 p.m.
> > > > To: sqlite-users@sqlite.org
> > > > Subject: [sqlite] File Is Encrypted Or Is Not a Database
> > > >
> > > > I have a sqlite db file. I have tried to open it with sqlite v
> > > > 3.4.1, 2.8.17 and 3.3.5 and each of these versions give
> > me the same
> > > > error "File Is Encrypted Or Is Not a Database". How can I
> > determine
> > > > what version of sqlite will open this db? The perl
> > application can
> > > > open the database using the perl module it has. But I cant get
> > > > command line access to the db. Any ideas?
> > > >
> >
> >
> > If you can open the database with Perl then it is not
> > encrypted. Check the version of DBD::SQLite you have
> > installed. Its docs will tell what version of SQLite it has
> > compiled in.
> >
> > Then, are you sure you are trying to open it with the right
> > versioned SQLite? Try
> >
> > $ which sqlite3
> >
> > to find out if you are inadvertently picking up an old SQLite
> > program installed somewhere in your path.
> >
> > --------------------------------------------------------------
>
> > ---------------
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > --------------------------------------------------------------
> > ---------------
> >
>
>
--
Puneet Kishor
http://punkish.eidesis.org/
Nelson Institute for Environmental Studies
http://www.nelson.wisc.edu/
Open Source Geospatial Foundation (OSGeo)
http://www.osgeo.org/
Summer 2007 S&T Policy Fellow, The National Academies
http://www.nas.edu/
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
