Re: [sqlite] Using SQLite on a networkshare

2013-01-11 Thread Stephen Chrzanowski
It boils down to that SQLite is working as intended as it can only rely on what the OS feeds it. As stated, the developers of SQLite are not going to be looking at network sharing as the responsibility of file locking is on the OS, not SQLite. Network sharing is tricky, and it "seems" seamless wh

Re: [sqlite] Using SQLite on a networkshare

2013-01-08 Thread Raymond Meester
Hi JCHD, Thnx for your notice. Of course I checked the AutoIt forum first. There is indeed some discussion on this topic, but no solution that worked for me. I also checked the solution by atensoft (actually I used this for a while, but couldn't find out how to properly write a wrapper for it in s

Re: [sqlite] Using SQLite on a networkshare

2013-01-07 Thread Jean-Christophe Deschamps
Raymond, So I checked some server/client solutions from http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork. But as there wasn't a solution that supported my script language (Autoit) I ended up writing my own server/client solution. This worked for me, but I still have some questions regarding th

Re: [sqlite] Using SQLite on a networkshare

2013-01-07 Thread Simon Slavin
On 7 Jan 2013, at 1:16pm, Raymond Meester wrote: >1) What is the best way to use sqlite on a networkshare (shared cache > mode / unlock notify / busy timeout etc)? I saw a lot of posts about issues > with >multiple connections when the db file is on networkshare, but for some > it seemed