> 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