Re: [sqlite] SQLITE in a Win7 Service Application

Make sure account SYSTEM or NT SYSTEM AUTHORITY has change access to the directories containig the database files.  Note also that local system has no acces to network shares drives or files Sent from Samsung Mobilemarkus ruettimann wrote:

[sqlite] sqlite_master and sessions

Hi, I'm using the Sessions extension, and I'm seeing a problem in which when calling sqlite3session_changeset(), it calls sessionSelectStmt with zTab="sqlite_master", which fails because that table has no primary key. I'm doing sqlite3session_attach(d->sqlSession, 0), so that should include

Re: [sqlite] SQLITE in a Win7 Service Application

If you're using impersonation, you'll run into problems doing any updates during the impersonation when sqlite tries to create any temporary files or reopen any it has closed. You can use Process Monitor from Sysinternals (now Microsoft) to see exactly what the failure is with what file. On

Re: [sqlite] SQLITE in a Win7 Service Application

Hello markus, Every Windows programmer needs to have "Procmon" installed on their system so, they can watch their program's disk IO. I'd suggest installing it, then using a filter to watch just your service. Then, you can simply watch what disk IO is failing. I use it on a daily basis. Almost as

Re: [sqlite] SQLITE in a Win7 Service Application

On Wed, Aug 15, 2012 at 11:19 PM, markus ruettimann < markus.ruettim...@trapezegroup.com> wrote: > Hi, > We are facing problems when the sqlite database () is used within an > application that runs as a Win7 service under the local system account. > The application is written in Java and we use

Re: [sqlite] SQLITE in a Win7 Service Application

On 15 Aug 2012, at 4:19pm, markus ruettimann wrote: > How ever we can create a new database, reading and writing to it withount > any problem. The only thing that is not working is the ATTACH DATABASE SQL > command. We constantly receive a CAN_NOT_OPEN

[sqlite] SQLITE in a Win7 Service Application

Hi, We are facing problems when the sqlite database () is used within an application that runs as a Win7 service under the local system account. The application is written in Java and we use the sqlite-jdbc-3.7.2 JDBC driver. How ever we can create a new database, reading and writing to it

Re: [sqlite] Update with nested selected

Steffen Mangold wrote: > I try to update a table field with a selected value from same tabel. Is this > possible? > What I try yet is: > update TableA Set FieldA = (select FieldB from TableA where IDField = > updateData.IDField AND TimeStamp = >

[sqlite] Update with nested selected

Hi sqlite user, I try to update a table field with a selected value from same tabel. Is this possible? What I try yet is: update TableA Set FieldA = (select FieldB from TableA where IDField = updateData.IDField AND TimeStamp = date(updateData.TimeStamp, '-1 day')); I want to update the FieldA