m> What is the best location on the server to store my application's
m> FDB file? Candidates would appear to be:

m> C:\Program Files\MyApp\Data
m> (where \Data is not visible to the clients and an alias is used for security reasons)

m> or

m> C:\Documents and Settings\All Users\Application Data\MyApp\

m> I'd be very grateful for any guidance or good/bad experiences.

Nothing good will ever come from an installation that does not
separate program file locations from data storage locations.

use c:\data\.... for storing your databases, or something similar.

As Milan already pointed out, do *NOT* put data into "program files".
With Firebird database it will probably work because FB Server usually
is run with "System" privileges.

@Milan: Win7 - if properly installed - will not ask for permission
each time, by the way. Put up UAC to highest level after install and
then folder and file virtualization will work quite good with Win7,
but can be even more irritating for many IT-NonProfessionals.


The way your question is written hints on the usage of hard coded
paths somewhere in your application. Do use aliases; seriously.
Have a look at firebird.conf and aliases.conf at the root of your
server.






---