Re: [sqlite] System.Data>SQLite locking problem

I can confirm that the problem only exist when the database is encrypted. On Sat, Sep 15, 2012 at 11:00 AM, Serge Fournier 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

Re: [sqlite] System.Data>SQLite locking problem

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 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

Re: [sqlite] System.Data>SQLite locking problem

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

Re: [sqlite] System.Data>SQLite locking problem

Did you try it with a Windows 8? I have a feeling that the problem is more with this OS then the library. Here's something simple that doesn't work: SQLconnect.ConnectionString = "Data Source=" & Application.StartupPath & "\data.db;" SQLconnect.SetPassword(infoConnection) SQLconnect.Open()

Re: [sqlite] System.Data>SQLite locking problem

I've experienced this problem in the past. According to here, 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"

Re: [sqlite] System.Data>SQLite locking problem

Serge Fournier wrote: > > Simply put, it's only possible to open a database once in the application > for writing; it's like the lock > doesn't get released until the application is closed. > I'm unable to reproduce the issue you describe here. Could you show us some sample code that

Re: [sqlite] System.Data>SQLite locking problem

Yes, all command have been disposed; everything works until I close the connection. Then when I open it again it the same application; either I get a "database is locked" when trying to write to it or I get "SQL queries are still processing" when I just opened it and send a VACUUM pragma to it.

Re: [sqlite] System.Data>SQLite locking problem

Serge Fournier wrote: > > Simply put, 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 >

[sqlite] System.Data>SQLite locking problem

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