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

2012-08-29 Thread markus ruettimann
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 written in Java and we

[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

Re: [sqlite] SQLITE in a Win7 Service Application

2012-08-15 Thread Simon Slavin
On 15 Aug 2012, at 4:19pm, markus ruettimann markus.ruettim...@trapezegroup.com 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 error

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 the

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 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 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 markus.ruettim...@trapezegroup.com wrote: