I had something very similar happen. In my case there was a journal file that was created by a service, so it had different file rights. My account didn't have rights to the journal, but when SQLite saw the journal there and wasn't able to play it back, it reported the database locked error. Changing the journal file rights solved it for me. If you deleted the journal file (if there was one) that might explain it in your case.
Doug > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Teg > Sent: Thursday, March 13, 2008 9:48 AM > To: General Discussion of SQLite Database > Subject: [sqlite] Weird locking issue Windows XP64 3.5.5 > > Hello All, > > Just thought I'd report this and see if anyone has any ideas. I'm > upgrading to 3.5.6 as I write this just in case. > > I had a DB file that reported locked in my application. I tried it > with Sqlite3.exe and it also reported it was locked. I exited the > application, exited the programming environment and shut > apps down one at a time till I had nothing running. The file > remained "locked". I copied the file to another filename, this file > wasn't locked and there was no issue with the copy. > > I was able to delete the original file and rename the copy as the > original filename. Now it's not locked any more. It seems as if there > was still some OS level lock on the file even thought the application > had exited. > > I'm sure I won't be able to reproduce this. It's never happened before > as far as I know. > > > -- > Best regards, > Conrad mailto:[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
