Re: [sqlite] Getting error "file is encrypted or is not a database" when trying simple C example

Yes I had done an "apt-get install sqlite" which had installed sqlite2. I removed it, installed sqlite3 and all is good now. On Mon, May 26, 2014 at 8:26 AM, Donald Griggs wrote: > Hi Fred, > > At the risk of informing you of something you may already know, > you should be

Re: [sqlite] Getting error "file is encrypted or is not a database" when trying simple C example

FYI: SQLite2.8.17 for some Linux-versions (and Apple ppc) can be found here: http://www.rpmfind.net/linux/rpm2html/search.php?query=sqlite2 Perhaps there are applications to convert to a more contemporary format like 3.8.4.3   Kind regards | Cordiali saluti | Vriendelijke groeten | Freundliche

Re: [sqlite] Getting error "file is encrypted or is not a database" when trying simple C example

Hi Fred, At the risk of informing you of something you may already know, you should be able to convert an sqlite version 2 database to sqlite3 easily using the command line commands as follows: sqlite OLD.DB .dump | sqlite3 NEW.DB http://www.sqlite.org/version3.html Donald

Re: [sqlite] Getting error "file is encrypted or is not a database" when trying simple C example

On 2014/05/25 23:07, Fred Basset wrote: I am using sqlite3 version 2.8.17 on an Arm Debian Linux system. There is no SQLite3 version 2.8.17... it's either SQLite 2 which may have had a version 2.8.17 or SQLite3 which only ever has versions 3.n.n.n and for which we still need to get to

Re: [sqlite] Getting error "file is encrypted or is not a database" when trying simple C example

On Sun, May 25, 2014 at 5:07 PM, Fred Basset wrote: > I am using sqlite3 version 2.8.17 on an Arm Debian Linux system. > SQLite version 2 and version 3 have incompatible file formats. You appear to have created a database using version 2 then tried to read that

[sqlite] Getting error "file is encrypted or is not a database" when trying simple C example

I am using sqlite3 version 2.8.17 on an Arm Debian Linux system. I created a test table using these commands from Linux: " cat 01_create_tables.sql CREATE TABLE PV_INTERVALDATA ( timestamp DATE, T_ambient REALNOT NULL, T_trunk1 REALNOT NULL, T_trunk4 REAL