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 version 3.8.17 somewhere down the line (current version is only at 3.8.4.n).
So, unless your statement has a typo regarding the version number, you seem to be making DBs in SQLite 2 and trying to open it with
SQLite 3 - which I assume will always fail as the file architecture is different (though I could be wrong, I only ever used SQLite3
and have never actually encountered an SQLite2 or earlier DB in the wild).
If this is the issue, the C makefiles etc. are all easily downloadable from the SQLite site so updating the Linux distro to use a
latest version is easy. If this is a widely deployed thing, it might be less easy, but I can't believe any recent (or even
not-so-recent) Linux distro would still include an SQLite 2 build, unless I'm very uninformed (which might well be).