Re: [sqlite] Network and concurrency

2014-11-26 Thread Stephen Chrzanowski
Try? Don't use a network. It isn't safe due to file locking mechanisms (As you've noted) at the server side, not the client side. The other option is to either build a SQLite server where the local database store is, or, get MySQL/MSSQL up and running. https://www.sqlite.org/whentouse.html Spe

Re: [sqlite] Network and concurrency

2014-11-26 Thread Mike McWhinney
I still get the crashes even after adding the pragma. My connection string looks like: public static string OMconnectionString = "URI=file:omm.db; PRAGMA busy_timeout = 15000" Is there anything else I can try? Mike On Wednesday, November 26, 2014 10:34 AM, Simon Slavin wrote: On 26

Re: [sqlite] Network and concurrency

2014-11-26 Thread Simon Slavin
On 26 Nov 2014, at 4:20pm, Mike McWhinney wrote: > Are there any other PRAGMA or connection string > statements that can help with this concurrency issue? If you haven't set a busy timeout then SQlite won't retry when there is a network clash, it will immediately return an error code. If you

[sqlite] Network and concurrency

2014-11-26 Thread Mike McWhinney
Hello, I am continuing to have sporadic problems with SQLite and a WinForms application that I'm developing. The program is a Winforms app using the System.Data.SQLite class. I am running this off a network. There are a small number of users which read and write to a database stored on a netwo