[sqlite] SQLITE_BUSY database is locked 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 shared db is now:  
/Volumes/SharedFolder/smalldb.db


the test app (which works perfectly with the same exact small db 
sitting on its local drive) is launched and a connection is made to the 
db sitting on the other mac.


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.


NO ONE else is accessing this database file, so how is that possible?


what am i doing wrong?

- chase



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] SQLITE_BUSY database is locked 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 shared db is now:  
/Volumes/SharedFolder/smalldb.db


the test app (which works perfectly with the same exact small db 
sitting on its local drive) is launched and a connection is made to the 
db sitting on the other mac.


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.


NO ONE else is accessing this database file, so how is that possible?


what am i doing wrong?

- chase



-
To unsubscribe, send email to [EMAIL PROTECTED]
-