RE: [sqlite] SQLite3 and version 2.1 DBs
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 Two point one? Is that version not over three years old, or did you mistype? What GUI tools do people use to manage their 3.x databases if that's the case? Haven't found the need to use a GUI tool yet, however, this one has been posted on the list a couple of times. I don't know if it's been updated to the version 3 DB format, http://www.kraslabs.com/sqlite/ It only says sqlite.dll version 2.7.2 or higher on the web site, so it might not work with 3.
Re: [sqlite] SQLite3 and version 2.1 DBs
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