At 10:46 PM 16/12/2004 +0000, Adam wrote:

> > How can I add an alias of a database that is not in the server?
> >
> > I mean, Is remotly in other server, is that possible?
> >
> > Thx.
>
>Yes but don't.
>
>Hard disk speeds are slow compared to RAM, but they are a lot faster
>than LAN speeds. Firebird is designed to read from a local disk, the
>faster the better. You will get horrendous performance even on an
>incredibly good LAN. You would also have to share the fdb file which
>is another really bad idea, because you lose security, anyone can
>become SYSDBA.

That's not the reason. If one server tries to write data to a database
that's controlled by another server, or even another CPU (no server
installed) corruption is inevitable. And it's not the kind of corruption
you can fix by using gifx to tidy up orphaned pieces.

Superserver actually prevents two servers from opening the same database,
even if the two servers are running on the same machine. Classic can't
prevent it.

"Sharing the DB file" is a different issue, that could be a security issue
if any old network user can get access to a DB file through networked file
sharing. At the database access level, by design, a client can't connect
to a share. On *nix, a foolish person can configure a parameter in
firebird.conf to allow it, and discover a whole galaxy of ways to trash
databases.

./heLen