On 3 Jul 2013, at 11:50pm, RSmith <rsm...@rsweb.co.za> wrote:

> Haven't been called "Simon" often in my life, I guess there's a first for 
> everything! :)

Strange.  I get it all the time.

> You have solved it halfway, but the Services have the exact same restrictions 
> as software in terms of what they are allowed to manipulate (well, not 
> exactly the same, but close enough to make no difference with your problem). 
> You have fixed the DB and moved it to a non-protected location, this should 
> work very well. The only reason your service is seeing a different file is 
> that it is still looking at the "other" non-safe location, or at a totally 
> different location altogether.

There are two problems, and they come up repeatedly on this and other lists:

(1) the 'default' folder for a Windows app changes depending on whether it’s 
your own code or a DLL opening a file for you.  So if you start using a 
precompiled DLL suddenly your app starts behaving differently for no apparent 
reason.
(2) Windows doing the UAC thing you explained so well in your previous post.

> It can't "Look" at something non-existing, there is no magic in the system, 
> it must abide by the security rules (and benefit from it).
> 
> SO, did you make the service or did someone else?
> 
> If you made it, the fix is easy. If someone else, did, they may have also 
> moved/placed the data to a separate location anticipating the UAC 
> restrictions. You will need to actually find the files referenced and 
> understand which file is accessed by which system (I mean the exact on-disk 
> bytes, not simply the referred name). adding specific data hashes to the 
> columns should provide a usable tell-tale.

The only solution I ever found (for a far earlier version of Windows) was to 
require a full path to be specified by the user, either asking for it to be 
typed in, or using the System call which presents the folder GUI and using the 
path it returns.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to