Re: [sqlite] Can write to database using API but get an error on writing with sqlite3.exe

2018-09-30 Thread Luiz Américo
Em qui, 27 de set de 2018 às 00:59, Luiz Américo escreveu: > > > Em qui, 27 de set de 2018 às 00:30, Keith Medcalf > escreveu: > >> >> Have you checked to make sure the ID that you are using (interactively) >> is permitted read/write access to the directory containing the db files and >> to the

Re: [sqlite] Can write to database using API but get an error on writing with sqlite3.exe

2018-09-26 Thread Luiz Américo
Em qui, 27 de set de 2018 às 00:30, Keith Medcalf escreveu: > > Have you checked to make sure the ID that you are using (interactively) is > permitted read/write access to the directory containing the db files and to > the files themselves? I mean *actually* checked that you have permission, >

Re: [sqlite] Can write to database using API but get an error on writing with sqlite3.exe

2018-09-26 Thread Keith Medcalf
Have you checked to make sure the ID that you are using (interactively) is permitted read/write access to the directory containing the db files and to the files themselves? I mean *actually* checked that you have permission, since I doubt that the CGI process is running with the same ID you

[sqlite] Can write to database using API but get an error on writing with sqlite3.exe

2018-09-26 Thread Luiz Américo
I have a 1GB database configured to use WAL mode. It's accessed by short lived CGI processes, under windows 2008 server. Each process usually opens the database, execute a select or update/insert, close the connection and finishes. It uses c api (sqlite3_open, sqlite3_prepare, sqlite3_step) of