Hello,
I have written a program in C# Visual Studio Winforms. In general the SQLite
database is working quite well.
However, lately we have been plagued with database locking errors:
Here is the exeption:
database is locked
database is locked
at
meout when the database
gets locked?
Thanks
Mike
On Wednesday, October 29, 2014 5:26 PM, Mike McWhinney <elja...@sbcglobal.net>
wrote:
I will let you know if this fixes the problem. So far I have not had any
locking issues. I will see tomorrow when it
receives more usage and tr
<slav...@bigfraud.org>
wrote:
On 30 Oct 2014, at 4:13pm, Mike McWhinney <elja...@sbcglobal.net> wrote:
> I have continued to receive the locking erros. The latest connection string I
> have as follows:
>
> public static string OMconnectionString = "URI=file:osle
Hello,
I continue to have random errors on SQLite.NET (ADO provider). I have the
version 3.8.6 (System.Data.SQLite.dll with version 1.0.94.0).
I am getting random locking errors during the execution of my program. The
program resides on a network and each client has a mapped share
with full
Hello,
I continue to have "database is locked errors" when running an application
which accesses a SQLite dabase on a network.
I have tried many of the connection string options: pooling, changing default
time out.
I just recently tried a block of code which does a BeginTransaction and
:41 AM, Mike McWhinney wrote:
> Please let know if there are any other solutions to this database
> locking problem as used on a network.
Yes. Do not do it. See the FAQ:
https://www.sqlite.org/faq.html#q5
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1
iEYE
I am using Sqlite.NET client in C#. How would I go about defining a sqlite busy
timeout handler?
Thanks
Mike
On Monday, November 10, 2014 1:35 PM, Tim Streater <t...@clothears.org.uk>
wrote:
On 10 Nov 2014 at 18:22, Mike McWhinney <elja...@sbcglobal.net> wrote:
> So S
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
avin <slav...@bigfraud.org>
wrote:
On 26 Nov 2014, at 4:20pm, Mike McWhinney <elja...@sbcglobal.net> 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 wh
Hello,
I am trying to troubleshoot a problem that I'm having with a program
usingSQLite over a wireless network.? I know that wireless networks can
havetheir own sets of issues that cause database access problems.
What is happening is that something that takes 1 or 2 seconds on a wirednetwork
Hellom,
I am using the c# variant of sqlite (system.sqlite.data.org) and am using a
connection string similar to this:
public static string OMconnectionString = "datasource=database.db; Default
Timeout=20; PRAGMA busy_timeout = 600; PRAGMA synchronous=Off";
I then use the following statements to
Hello,
I am using SQLite in a Windows environment. The file storing the database is on
a Windows 2008 server.All other file access to this server is reasonably fast.
However, when doing simple SELECTS and INSERTS/UPDATESit is noticeably slower
on a network. I am talking about 50 records.
Now I
12 matches
Mail list logo