I recently reported a similar error. After upgrading to sqlite3, I noticed that I would occassionally get the "database disk image is malformed" errors using the library code. I just closed/reopened the db, retried the query and always had success on the retry. No idea why - D. Richard Hipp says that it's not possible for a database to be temporarily corrupt.
I've also sometimes observed a "some_table doesn't exist" error. Closing/reopening and retrying the query also always works. I think that it's a good idea to have a wrapper around the sqlite library that will retry queries a few times if they don't return SQLITE_OK. This is especially useful in the cases when the db is busy but the busy handler isn't called (because apparently that would cause deadlock). Kevin --- Leander Gillard <[EMAIL PROTECTED]> wrote: > Hello, > > Just wondering why I get this error when trying to > open the DB with the Binary interface. It has > actually worked on the odd occasion. > > sqlite l_main.dbl > Unable to open database "l_main.dbl": database disk > image is malformed > > > Regards, > > > Leander __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com