Any clues? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Topov Sent: Monday, April 14, 2008 5:02 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file
I am on Windows XP using sqlite 3.5.6 dll created from the source. I debugged the code - Sqlite3_open returns OK but any other function after that returns 1. For example sqlite3_prepare returns 1 when I do "Select * from sqlite_master". Same for sqlite3_execute. Tried different SQL statements - same error. If I switch to 3.3.5 dll the problem goes away. Regards. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp Sent: Monday, April 14, 2008 4:46 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file On Apr 14, 2008, at 4:30 PM, Steve Topov wrote: > I already reported this bug but did not receive any responds so I am > trying one more time. > The problem: > SQLite version 3.5.6 and up returns an error when opening some > database > files. The error is “SQL logic error or missing database”. > Version prior to version 3.5.6 works fine with these database files. > > I do not know the version of SQLite the database file in question was > created with. And I am talking about SQLite 3 database file – not > SQLite > 2, not Microsoft Access, > not any other file format. > > To make story short: SQLite 3.5.6 can not open SQLite 3 database file. > > I'm working with the file named "dpdshop.sl3" that you sent me, 5444608 bytes in size. MD5 checksum 9fa76c1610a5e7c826d2745191e7a401 I can open and read this file without problems on MacOSX using SQLite version 3.4.0, 3.5.6, 3.5.7 and the latest in CVS. I ran PRAGMA integrity_check using all four versions of SQLite and all return "ok". D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users