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
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.
[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? What GUI tools do people use to manage their 3.x databases if that's the case? Thanks. Bryan McRoberts __ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250