Subject RootDirectory and location of database files
Hey all,

On my new server configuration, I'm taking advantage of aliases
(alias.conf) and the setting in the firebird.conf called
DatabaseAccess. What I can't figure out though is why (under Windows)
the default location it tries to create a database is under
C:\Windows\System32, even though I've specified what my RootDirectory
is in the configuration file.

My ideal is that remote users creating databases should have no
knowledge that firebird is on the E: drive, in a specific directory.

For example, I imagined that the creator of a new database should be
able to use syntax like this:

create database 'theserver:data/newdb.fdb'

Something like that.

Anyway, I get the following error when I attempt to do that:

Access to database "C:\WINDOWS\SYSTEM32\DATA\TEST.FDB" is denied by
server administrator

The only way for a remote user to create a database in my
E:\Firebird_1_5\data directory is for them to expressly specify that path.

Shouldn't RootDirectory somehow get involved here and at least let
stuff get created relative to RootDirectory?

By the way - I tried creating a special user for the fbguard and
fbserver services, and set it's home directory to E:\Firebird_1_5.
Same problem.
Am I missing a setting somewhere?

Thanks for your help.