Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

What's the programming language used in the application? I use Freepascal / Lazarus as a programming language and my own sqlite wrapper written in Freepascal as well. I will add the sqlite3_extended_errcode + sqlite3_errstr to the wrapper lib in order to get extended error infos and will

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

On 2016/06/13 3:41 PM, Luc DAVID wrote: Thanks Ryan and Oliver for your answers You are too fast for me, I didn't have the time to answer the first posts... @Ryan > There is no safe way to do what you need. Networked file systems do not > play nice with file-locking. SQLite is suitable for

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

> Le 13 juin 2016 à 15:41, Luc DAVID a écrit : > > The worst case is when you get a "Database is locked" message which mean you > have to kill all the application processes in order to unlock the db (unless > another means exists ?) You shouldn't get any such with

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

Thanks Ryan and Oliver for your answers You are too fast for me, I didn't have the time to answer the first posts... @Ryan > There is no safe way to do what you need. Networked file systems do not > play nice with file-locking. SQLite is suitable for localized storage, > not

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

On 2016/06/13 3:12 PM, Olivier Mascia wrote: Le 13 juin 2016 à 15:02, R Smith a écrit : The application will be used by ± 10 users via RDP TSE clients. Hi Luc, There is no safe way to do what you need. Networked file systems do not play nice with file-locking. SQLite

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

> Le 13 juin 2016 à 15:02, R Smith a écrit : > >> The application will be used by ± 10 users via RDP TSE clients. >> > Hi Luc, > There is no safe way to do what you need. Networked file systems do not play > nice with file-locking. SQLite is suitable for localized storage,

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

> Le 13 juin 2016 à 14:20, Luc DAVID a écrit : > > Hello, > > I'm planning to install an application using sqlite on a windows 2003 > server. > > The application exe + sqlite dll + database will be installed in the same > server directory. Best would be to compile

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

On 2016/06/13 2:20 PM, Luc DAVID wrote: Hello, I'm planning to install an application using sqlite on a windows 2003 server. The application exe + sqlite dll + database will be installed in the same server directory. The application will be used by ± 10 users via RDP TSE clients. I need to

[sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

Hello, I'm planning to install an application using sqlite on a windows 2003 server. The application exe + sqlite dll + database will be installed in the same server directory. The application will be used by ± 10 users via RDP TSE clients. I need to take care of possible database locks