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
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
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
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
4 matches
Mail list logo