The db I am trying to open is attached. Thanks > -----Original Message----- > From: P Kishor [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 5 December 2007 6:11 p.m. > To: [EMAIL PROTECTED] > Cc: sqlite-users@sqlite.org > Subject: Re: [sqlite] File Is Encrypted Or Is Not a Database > > 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] > -------------------------------------------------------------- > --------------- >
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------