Subject Re: Embedded Database from server share.
Author Adam
> Using the embedded server with the config file. I cannot seem to
make it
> work.
> I have the dB, fbembed.dll, and the firebird.conf with only this
> RemoteFileOpenAbility = 0 all in the same dir. It still will not
connect. Am
> I missing something?

That makes perfect sense:

<snip>
Unless this configuration option is changed from 0 to 1, Firebird can
open a database only if the database is stored on a drive physically
attached to the local computer
</snip>

You really need to understand the risk of database corruption in this
mode, the lack of any ability to control security, that you may
encounter issues with UDFs, that you will definately encounter
performance issues and the simplicity of setting up a service which
would solve all of these problems. If it was a hard thing to do I
could understand, but in all honesty, I think this is crazy.

Adam

> ># ----------------------------
> ># Remove protection against opening databases on NFS mounted volumes
> >#
> ># ***WARNING*** ***WARNING*** ***WARNING*** ***WARNING***
> >#
> ># This option removes an important safety feature of Firebird and can
> ># cause irrecoverable database corruption. Do not use this option
unless
> ># you understand the risks and are prepared to accept the loss of the
> ># contents of your database.
> ># Unless this configuration option is changed from 0 to 1, Firebird can
> ># open a database only if the database is stored on a drive physically
> ># attached to the local computer – the computer running that copy of
> ># Firebird. Requests for connections to databases stored on NFS mounted
> ># drives are redirected to a Firebird server running on the
computer that
> ># "owns" the disk.
> ># This restriction prevents two different copies of Firebird from
opening
> ># the same database without coordinating their activities.
Uncoordinated
> ># access by multiple copies of Firebird will corrupt a database. On
a local
> ># system, the system-level file locking prevents uncoordinated
access to
> ># the database file.
> ># NFS does not provide a reliable way to detect multiple users of a
file on
> ># an NFS mounted disk. If a second copy of Firebird connects to a
> >database on
> ># an NFS mounted disk, it will corrupt the database.
> ># Under some circumstances, running a Firebird server on the
computer that
> ># owns NFS mounted volumes is inconvenient or impossible.
Applications that
> ># use the "embedded" variant of Firebird and never share access to a
> >database
> ># can use this option to permit direct access to databases on NFS
mounted
> ># volumes.
> ># DO NOT ENABLE THIS OPTION UNLESS YOU REALLY KNOW WHAT YOU ARE DOING.
> >#
> ># Type: boolean
> >#
> >#RemoteFileOpenAbility = 0
> >