As I said before...welcome to DLL hell...
You guessed it....the original DLL will give an error if any of the DLLs it depends on are not loadable. Since sqlite.interop.dll is non-standard you should include ALL DLLs that it depends on in your installation. Subject to Microsoft's restrictions: http://msdn.microsoft.com/en-us/library/8kche8ah.aspx How are you making your installation distribution? Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________ From: [email protected] [[email protected]] on behalf of Singh, Manpreet [[email protected]] Sent: Tuesday, June 21, 2011 2:55 AM To: [email protected]; [email protected] Subject: EXT :Re: [sqlite] Help sqlite database corruption Anyone with clues to the problem "malformed disk image"? From: Singh, Manpreet Sent: Tuesday, May 24, 2011 3:10 PM To: [email protected]; [email protected]; [email protected] Cc: Singh, Abhijeet; Singh, Satbeer; Prasanth, Neelapalem Subject: RE: Help sqlite database corruption Hello, Resending with some more finding any help would be appreciated. One of the tables in the database is getting corrupted. 1. Sqlite>select count(*) from $table_name ...... 7981508|35001|284 7981509|35002|284 7981510|35003|284 7981511|35004|284 SQL error: database disk image is malformed sqlite> 2. When integrity check is performed following is the error: *** in database main *** Page 703104: sqlite3BtreeInitPage() returns error code 11 On tree page 680368 cell 75: Child page depth differs Page 703365: sqlite3BtreeInitPage() returns error code 11 Page 703624: sqlite3BtreeInitPage() returns error code 11 Page 703884: sqlite3BtreeInitPage() returns error code 11 Note: 1. $table_name has 2 unique indexes and 3 columns 2. Using Sqlite version 3.5.6 3. We are able to .dump to sql file and get the db back Thanks and Regards, Manpreet Singh CA Subject Matter Expert SQL Certified (Oracle 9i) MCP (SQL 2000 Administration) MS Certified Technology Specialist - SQL Server 2005 From: Singh, Manpreet Sent: Wednesday, May 18, 2011 12:04 PM To: '[email protected]' Subject: Help sqlite database corruption Hello, Looking for help, sqlite database getting corrupted multiple times we need to use .dump to recover and then back to database. As per our observations index gets corrupted for one of the tables (table goes more than 7900k records) and when queried it give "malformed disk image" for that database. Thanks and Regards, Manpreet Singh _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
