The thing here is that my code was working perfectly with the prior version of the library and Windows 7. The same code with 1.0.82 and Windows 8 doesn't work anymore.
I cannot use your solution, because the way my appliation works; it creates the database at first run and miust be able to run on many computers. I've tried recreating the database; and so many things; the only thing that works is to only open the database once in my application which is no a good solution for me since I have to remove some functions like VACUUM etc... Thanks. On Tue, Sep 11, 2012 at 3:18 PM, Brandon Pimenta < brandonskypime...@gmail.com> wrote: > I've experienced this problem in the past. According to > here<http://technosophos.com/node/242>, > I found a solution. > > *Brandon's Tips on How to Unlock SQLite Databases* > > 1. Open a command line prompt window. > 2. Type *sqlite* *dbname*.sqlite in the command line prompt, replacing > "dbname" with the SQLite database name. > 3. In the secondary prompt that appears, type *.backup* full *dbname* > .sqlite, replacing "dbname" with the SQLite database name. > 4. Type *.exit *to return to the ordinary command prompt. > 5. Type *mv* *dbname*.sqlite old.sqlite, then *mv* backup.sqlite > *dbname* > .sqlite in the command line, replacing "dbname" with the SQLite database > name. > 6. Try the task you were attempting to do before you did all of the > above instructions. > 7. *You are done!* > > *Brandon Sky Pimenta* > > > On Tue, Sep 11, 2012 at 10:35 AM, Serge Fournier <tech...@gmail.com> > wrote: > > > Hi, > > > > I'm not sure if it's Windows 8 or the latest version of the library > > (1.0.82) but I have a new > > problem with the same code that was working before. > > > > Simply put, i I open a database and then close it in an application then > I > > reopen it again, > > I cannot write to it anymore; it is always locked. I tried doing a close, > > dispose and shutdown > > to my connection and then reopning it and do a simple vaccum; it tell me > > that there's still > > sql queries in progress when none were sent to the database. > > > > I cannot test this in Windows 7 yet, but I'm wandering if it's a problem > > with Windows 8; or > > a bug in the new version of System.Data.SQlite. > > > > I use Visual Studio 2010. > > > > Thanks. > > _______________________________________________ > > 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
