Hi Chase,
it connects fine. no errors. but then i try to create a temp
table (which, like i said, works if the db is local) it fails
immediately with SQLITE_BUSY "database is locked".
It's some Mac vs SQLite bug. You can recompile SQLite to fix it. See
the old post below. And search the archives for "locked" in the subject.
Tom
----
From: T&B <[EMAIL PROTECTED]>
Date: 11 May 2007 10:54:02 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] database is locked error
Is there a timetable for including the fix for opening SQLite files
on a shared volume? Since it's fairly trivial, is there a reason why
it hasn't been included yet?
Thanks,
Tom
----
From: T&B <[EMAIL PROTECTED]>
Date: 29 April 2007 3:35:00 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] database is locked error
Following up an old thread:
The SQLite sources include an (Apple-supplied) patch to work around
the problem. Recompile
with
-DSQLITE_ENABLE_LOCKING_STYLE=1
We are working toward turning on this patch by default, but we are
not quite there yet.
I compiled and ran SQLite 3.3.17 and got the old error again when
accessing a database file on a server volume, with SQLite saying it
is locked.
Does this mean that we are still "not quite there yet" with a default
fix? Any time frame?
Thanks,
Tom
--
Best value broadband in Australia.
$3 per GB excess instead of $150 from BigPond
Free uploads, free morning downloads.
http://www.tandb.com.au/broadband/?sig
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
