do you have any ... SqliteCommand's laying around that aren't finished? On Thu, Mar 5, 2015 at 12:34 PM, RNACS - Info <info at rnacs.com> 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 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 new folder, the > program fails when I try to delete the old folder. The error message says > that the folder cannot be deleted because the SQLite database file is in > use > by another process. > > 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 > > ' Move data files > '\\\\\ code to move files goes here > > ' Delete old directory > Directory.Delete(strOldLocation, > FileIO.DeleteDirectoryOption.DeleteAllContents) > > The error occurs when I try to execute the "Directory.Delete" statement. > > "SQLconn" is a SQLiteConnection to my database file. Once the connection > is > closed & disposed of, what still has the .db file still open? How do I > close the file so I can delete it? > > Thank you for any assistance. > > Ray Andrews > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
