Re: [sqlite] Exception writing to database from multiple processes

2009-10-16 Thread David Carter
Thanks everyone for your suggestions. The locking was caused by not resetting / finalizing the statements in my transactions. Thanks again, David -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Crenshaw Sent: Friday,

Re: [sqlite] Exception writing to database from multiple processes

2009-10-15 Thread David Carter
the same time, nobody connecting to database via command line tool, nothing happens at all? Pavel On Thu, Oct 15, 2009 at 2:40 AM, David Carter wrote: > Hello, > > > > I am currently using the SQLite Amalgamation v3.6.19 from > http://www.sqlite.org/download.html in an ISAPI Exte

[sqlite] Exception writing to database from multiple processes

2009-10-14 Thread David Carter
Hello, I am currently using the SQLite Amalgamation v3.6.19 from http://www.sqlite.org/download.html in an ISAPI Extension to write out usage statistics to an SQLite database. When the ISAPI extension is running inside an Application Pool with a single worker process, everything works fi