Re: [sqlite] Database is locked Query

On 9/29/05, Gaurav Patole <[EMAIL PROTECTED]> wrote: > > Hello, > > I have a database file placed onto a NTFS LAN based local server. > Application's on different machines tries to access this database file and > update it frequently. from: http://www.sqlite.org/cvstrac/wiki?p=WhenToUseSqlite *

[sqlite] Database is locked Query

Hello, I have a database file placed onto a NTFS LAN based local server. Application's on different machines tries to access this database file and update it frequently. I am using Christian Werner's ODBC Driver. I am facing "Database is locked" problem. * Is concurrency weak in SQli

Re: [sqlite] Database is locked on SELECT only calls?

D. Richard Hipp wrote: Please run your program in a debugger and tell me what the subroutine "isNT()" returns in os_win.c. If it is returning false, that would explain your occasional inability to get a read lock on a read-only database. Perhaps a windows programmer can suggest a better impl

Re: [sqlite] Database is locked on SELECT only calls?

isNT() returns 1(true) I've only seen this database lock problem while access the db file on the (slow) NAS - local file systems seem to work fine. Even accessing it through one of our Windows shares seems to work fine. I'll keep you posted if I find any more information related to this problem.

Re: [sqlite] Database is locked on SELECT only calls?

Please run your program in a debugger and tell me what the subroutine "isNT()" returns in os_win.c. If it is returning false, that would explain your occasional inability to get a read lock on a read-only database. Perhaps a windows programmer can suggest a better implementation of the isNT() fu

Re: [sqlite] Database is locked on SELECT only calls?

ent. Regards Massimo John Duprey <[EMAIL PROTECTED]> on 21/06/2005 22.59.12 Please respond to sqlite-users@sqlite.org To:sqlite-users@sqlite.org cc: Subject:[sqlite] Database is locked on SELECT only calls? Hi All, I'm using sqlite 3.2.0 - the native C/C++ interface. I'

[sqlite] Database is locked on SELECT only calls?

Hi All, I'm using sqlite 3.2.0 - the native C/C++ interface. I'm seeing something that I haven't seen before. I have 4 programs accessing the same db file. The db file is on a slow Windows network share (NAS device). The 4 programs are the only processes accessing the DB file and all of them a

Re: [sqlite] database is locked

[EMAIL PROTECTED] wrote: [DQL statements ("SELECT ...") lock the whole database when using PySQLite.] Hi, I've thought about this whole issue and made a few changes to my local working copy of PySQLite over the weekend, which will go into the next release (during the next days): The most import

Re: [sqlite] database is locked

-- Initial Header --- >From : "Gerhard Häring" [EMAIL PROTECTED] To : "sqlite-users" [EMAIL PROTECTED] Cc : Date : Fri, 21 Nov 2003 16:43:26 +0100 Subject : Re: [sqlite] database is locked > [EMAIL PROTECTED] wrote: >

Re: [sqlite] database is locked

[EMAIL PROTECTED] wrote: Hi all, I'm trying SQLite with Zope You're using PySQLite, right? and it works fine, but when I use the browser's [Stop] button to interrupt the request it gives me the message: "database is locked" [...] This happens when you have a connection that is within a transac

[sqlite] database is locked

Hi all, I'm trying SQLite with Zope and it works fine, but when I use the browser's [Stop] button to interrupt the request it gives me the message: "database is locked" At this point it is not possible to continue the work unless I restart the Zope daemon. What can I do to avoid this behavior

<    1   2   3