I am sure on the versions of sqlite I have been using. When yoy run them it always shows the version of sqlite you are running. This is very very frustrating. I have a sqlite db which the Perl app is opening fine using DBIx::SimplePerl, yet U cannnot open the db from command line. It seems more than a little strange that I cannot determine the version of a sqlite db.
> -----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] -----------------------------------------------------------------------------