[sqlite] db File Remains Open After Connection is Closed

Hi Ray, Sqlite.Net implements a connection pooling scheme. Even when your connection is closed, the unmanaged database handle may still be open. After you have disposed of your connection object and are ready to do file-level operations, do something like this:

[sqlite] db File Remains Open After Connection is Closed

Please also note that setting an object to 'nothing' does _not_ dispose it! This was the case back in the VB6 days, but in the .NET world you need to enclose all objects implementing 'IDisposable' in a 'using' block or call Dispose() explicitly on all your objects to properly release any

[sqlite] db File Remains Open After Connection is Closed

ists.sqlite.org] On Behalf Of Simon > Slavin > Sent: Thursday, March 05, 2015 3:58 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] db File Remains Open After Connection is Closed > > >> On 5 Mar 2015, at 8:34pm, RNACS - Info wrote: >> >> The

[sqlite] db File Remains Open After Connection is Closed

On 5 Mar 2015, at 9:23pm, RNACS - Info wrote: > Does not help. I put a breakpoint at the "SQLconn = Nothing" statement & > checked the value of SQLconn.State. It was "Closed", so I continued one & > still got the error. Okay. Worth checking. I'm afraid I don't know your API well enough to

[sqlite] db File Remains Open After Connection is Closed

> On 5 Mar 2015, at 8:34pm, RNACS - Info wrote: > > The code I am using is: > >' Close license database connection >If Not IsNothing(SQLconn) Then >If SQLconn.State <> ConnectionState.Closed Then >SQLconn.Close() >End If >

[sqlite] db File Remains Open After Connection is Closed

[mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, March 05, 2015 3:58 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] db File Remains Open After Connection is Closed > On 5 Mar 2015, at 8:34pm, RNACS - Info wrote: > > The co

[sqlite] db File Remains Open After Connection is Closed

: Thursday, March 05, 2015 3:45 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] db File Remains Open After Connection is Closed do you have any ... SqliteCommand's laying around that aren't finished? On Thu, Mar 5, 2015 at 12:34 PM, RNACS - Info wrote: > I have a program writ

[sqlite] db File Remains Open After Connection is Closed

I have a program written in Visual Basic .NET. One of the functions of the program is to move all of the program's data, including a SQLite database to a different folder. The program is a 32-bit application using System.Data.SQLite.dll. I am having a problem that after I copy the data to the

[sqlite] db File Remains Open After Connection is Closed

do you have any ... SqliteCommand's laying around that aren't finished? On Thu, Mar 5, 2015 at 12:34 PM, RNACS - Info wrote: > I have a program written in Visual Basic .NET. > > One of the functions of the program is to move all of the program's data, > including a SQLite database to a