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



Reply via email to