Re: [sqlite] sqlite db is locked on network drive

2014-09-12 Thread Mark Halegua
On Saturday, September 13, 2014 01:10:37 AM Kees Nuyt wrote: > On Sat, 13 Sep 2014 00:55:23 +0200, Kees Nuyt > > wrote: > > It works better on your local filesystem. > > Perhaps you can configure (a partition on) the Seagate GoFlex as > an iSCSI target and configure an iSCSI

Re: [sqlite] sqlite db is locked on network drive

2014-09-12 Thread Kees Nuyt
On Sat, 13 Sep 2014 00:55:23 +0200, Kees Nuyt wrote: > It works better on your local filesystem. Perhaps you can configure (a partition on) the Seagate GoFlex as an iSCSI target and configure an iSCSI initiator on the PC ? A quick websearch on "seagate goflex iscsi" suggests

Re: [sqlite] sqlite db is locked on network drive

2014-09-12 Thread Kees Nuyt
On Fri, 12 Sep 2014 18:33:46 -0400, Mark Halegua wrote: >On Friday, September 12, 2014 09:43:39 PM Simon Slavin wrote: >> On 12 Sep 2014, at 9:15pm, Mark Halegua wrote: >> > On Friday, September 12, 2014 06:57:21 PM Simon Slavin wrote: >> >>

Re: [sqlite] sqlite db is locked on network drive

2014-09-12 Thread Mark Halegua
On Friday, September 12, 2014 09:43:39 PM Simon Slavin wrote: > On 12 Sep 2014, at 9:15pm, Mark Halegua wrote: > > On Friday, September 12, 2014 06:57:21 PM Simon Slavin wrote: > >> On 12 Sep 2014, at 5:28pm, Mark Halegua wrote: > >>> The db

Re: [sqlite] sqlite db is locked on network drive

2014-09-12 Thread FarSight Data Systems
when I try an insert I get this: Error: database is locked Mark On Friday, September 12, 2014 06:57:21 PM Simon Slavin wrote: > On 12 Sep 2014, at 5:28pm, Mark Halegua wrote: > > The db file is stored on a seagate goflex device as my kinda file server. > > on that

Re: [sqlite] sqlite db is locked on network drive

2014-09-12 Thread Simon Slavin
On 12 Sep 2014, at 9:15pm, Mark Halegua wrote: > On Friday, September 12, 2014 06:57:21 PM Simon Slavin wrote: >> On 12 Sep 2014, at 5:28pm, Mark Halegua wrote: >>> The db file is stored on a seagate goflex device as my kinda file server.

Re: [sqlite] sqlite db is locked on network drive

2014-09-12 Thread Keith Medcalf
>when I try an insert I get this: >Error: database is locked Is that a "goflex" USB device or the network device? If the network device this likely means that you are attempting to use the device in a manner for which it was not designed. ___

Re: [sqlite] sqlite db is locked on network drive

2014-09-12 Thread Mark Halegua
On Friday, September 12, 2014 06:57:21 PM Simon Slavin wrote: > On 12 Sep 2014, at 5:28pm, Mark Halegua wrote: > > The db file is stored on a seagate goflex device as my kinda file server. > > on that device I can open the db to read but not to write to. > > Do you get

Re: [sqlite] sqlite db is locked on network drive

2014-09-12 Thread Simon Slavin
On 12 Sep 2014, at 5:28pm, Mark Halegua wrote: > The db file is stored on a seagate goflex device as my kinda file server. on > that device I can open the db to read but not to write to. Do you get an error message ? Or do your changes just disappear ? If it's an

[sqlite] sqlite db is locked on network drive

2014-09-12 Thread Mark Halegua
I'm developing an application, for single users, using python and wxpyton with pysqlite. I often go into the database via sqlite3 to modify stuff or add records to tables for testing. The db file is stored on a seagate goflex device as my kinda file server. on that device I can open the db