I've found a weird and annoying problem when running a delphi made service which uses sqlite on a vista machine.
The sqlite wrapper i'm using, with a few tweaks to allow for multiple connections, came from here: http://www.itwriting.com/blog/a-simple-delphi-wrapper-for-sqlite-3/comment-page-1#comment-133030
Great wrapper, simple and easy to use.
On windows XP, which is what I use for everything, if i create a service that writes to and reads from an sqlite database, it works just fine. If I have another app reading from that database, I also see the updates coming through exactly as expected.
If I run the same service on a vista machine, it sems to do as required, but, if I then run a second app, reading from the same database file, the data is not correctly shown. It seems to not get the updates the service is applying, and this only happens when using a service app.
If you download sqliteman and run the same query over and over, after your service updates the tale, the updates dont show in sqliteman. if you do the same test with an identical application instead of the service, every update is shown in sqliteman.
I've build two examples.using delphi 2006 one is a service, and one is a normal windows app. install and uninstall bat files are included. once you have the service running, rename the normal app to something like, normtest, and copy it into the service folder, then run it, and keep pressing the update. you will see that the value is the same each time, and yet if you look in the services debug.txt file, the values seem correct.
Hope this makes sense. I've included all files in a zip for anyone who wants to have a look at this wierd issue.
The database files have been renamed from data.db to data.doc so they would upload, so you'll need to switch the filenames back again.
In care theres a problem with the attachement, I've also uploaded it to here: