Re: [sqlite] SQLITE in a Win7 Service Application [SOLVED]

2012-08-29 Thread markus ruettimann
012 17:20 Betreff: [sqlite] SQLITE in a Win7 Service Application Gesendet von: sqlite-users-boun...@sqlite.org 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 writte

Re: [sqlite] SQLITE in a Win7 Service Application

2012-08-15 Thread Keith Medcalf
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:

Re: [sqlite] SQLITE in a Win7 Service Application

2012-08-15 Thread Robert Myers
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

2012-08-15 Thread Teg
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

2012-08-15 Thread Mohd Radzi Ibrahim
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

2012-08-15 Thread Simon Slavin
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

2012-08-15 Thread markus ruettimann
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