Hi there, I've searched around and found a few threads like this: http://sqlite.phxsoftware.com/forums/t/2480.aspx
Basically, I have the same issue. When access the sqlite database via a website (MVC3 running on IIS) the first time, sqlite works fine. I properly call connections.Close() when I'm done... And the next time I try to access it I get: System.InvalidOperationException: No connection associated with this command Manually stopping the dev web server, or restarting the iis application pool fixes this for one more page view. It seems like the IIS config is leaving the process hanging around, and after calling close there (I guess) must be some handle which is being kept and keeping a reference to the database, preventing anything else from accessing it. Seeing as how this has happened to a few people, I was hoping someone here had seen this before and had a solution? I'm using the Precompiled Binaries for 32-bit Windows (.NET Framework 4.0) from http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki(32 bit mode enabled on iis), but I've tried the 64-bit version with the same result. Cheers, Doug. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
