> I have built sqlite3.lib from the source tarball, and
> when I try to create a statement in my 2.1 DB (created
> via SQLite Database Browser 1.01 from
> sqlitebrowser.sf.net) I get an error message that the
> file is encrypted. I've also used SQLite Control
> Center (v0.06) against the db, so I know it's good. I
> suspect the problem may be that sqlite3 simply doesn't
> play nice with DB's created by these utilities in 2.1
> format.  Is this correct?

Yes.  The file format changed between 2.8.x and 3.0.  See

http://www.sqlite.org/version3.html

That page also has a note about how to migrate data.

To Brass Tilde and others who wondered about the 2.1 version number:
Version 2.8.x has a string at the beginning of the database which says:

"** This file contains an SQLite 2.1 database **"

so that may be where Bryan got the version number from.  Is that true, Bryan?


> What GUI tools do people use
> to manage their 3.x databases if that's the case?

I haven't tried it myself, but you might want to look at Mike
Cariotoglou's sqlite3Explorer:

http://www.sqlite.org/contrib/download/sqlite3Explorer.zip?get=5

There are also other goodies in the contrib section:

http://www.sqlite.org/contrib

HTH

Ulrik Petersen
-- 
Ulrik Petersen, Denmark


Reply via email to