Re: [sqlite] "database is locked" SQLITE_BUSY when db is on network drive...

2007-08-03 Thread T
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

Re: [sqlite] "database is locked" SQLITE_BUSY when db is on network drive...

2007-08-02 Thread Mitchell Vincent
Can you do any other write queries (INSERT or UPDATE for example)? On 8/2/07, Chase <[EMAIL PROTECTED]> wrote: > > running sqlite 3.4.1 on mac os x 10.4 > > i've set up a file share on another mac running 10.4 and placed a small > db file on the share and chmod'ed it to 777 (full access). > > i

[sqlite] "database is locked" SQLITE_BUSY when db is on network drive...

2007-08-02 Thread Chase
running sqlite 3.4.1 on mac os x 10.4 i've set up a file share on another mac running 10.4 and placed a small db file on the share and chmod'ed it to 777 (full access). i go to the development mac and log into the other mac as the user who owns that db file. the path on my dev mac to that