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() sqlconnect.close() sqlconnect.dispose() Dim SQLconnect As New SQLite.SQLiteConnection Dim SQLcommand As New SQLite.SQLiteCommand Dim SQLreader As SQLite.SQLiteDataReader Dim SQLquery As String SQLconnect.ConnectionString = "Data Source=" & Application.StartupPath & "\data.db; SQLconnect.SetPassword(infoConnection) SQLconnect.Open() SQLquery = "VACUUM" Try SQLcommand = SQLconnect.CreateCommand SQLcommand.CommandText = SQLquery SQLcommand.ExecuteNonQuery() SQLcommand.Dispose() Catch sqlexception As SQLite.SQLiteException MessageBox.Show(sqlexception.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error) Catch ex As Exception MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon .Error) End Try It gives the "Still SQL queries to process" error. On Tue, Sep 11, 2012 at 10:07 PM, Joe Mistachkin <sql...@mistachkin.com>wrote: > > 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 demonstrates the issue? > > -- > Joe Mistachkin > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
