Simon,

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.

Ray

-----Original Message-----
From: [email protected]
[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 <info at rnacs.com> 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
>            SQLconn = Nothing
>        End If

After "SQLconn.Close()", check again the state of the connection to see if
it was successfully closed.  If not, display an error message.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to