Hello,
I am using System.Data.SQLite.dll version 1.0.82.0 and SQLite.Interop.dll to
connect to some SQLite databases using C# Web Services. The code is working
fine on Windows Server 2008, but on 2003 it is not releasing the database at
the end of the call. It is extremely simple code, just to connect, update a
record, then close and dispose is being called. I have tried a using(){},
which should automatically call the close and dispose as well as a
try{ExecuteNonQuery()}finally{Close()}, but for some reason that database file
remains locked well after the script has ran. Sometimes it can take a few
seconds up to a few minutes to close on the 2003 server(which works fine on the
2008 server). It might just be some setting for the IIS Worker Process, but I
don't know where else to look. If I manually end the w3wp.exe, it will then
release the file back to the computer. Has anyone ran into this issue? What
other settings should I look for? Let me know when you get a chance, and I lo
ok forward to hearing back.
James Johnston
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
