I can confirm that the problem only exist when the database is encrypted. On Sat, Sep 15, 2012 at 11:00 AM, Serge Fournier <tech...@gmail.com> wrote:
> I work with an encrypted database and it look like it could be part of the > problem. > > > On Wed, Sep 12, 2012 at 3:05 PM, Serge Fournier <tech...@gmail.com> wrote: > >> Doing more testing on this I can say that I have the same problems with >> Windows 7. >> >> >> On Wed, Sep 12, 2012 at 8:08 AM, Serge Fournier <tech...@gmail.com>wrote: >> >>> 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