Subject Re: Remote Database files
Author salisburyproject
--- In, Helen Borrie <helebor@t...>
> At 01:03 AM 16/11/2005 +0000, you wrote:
> >Hi,
> >
> >I am not very experienced with Firebird and I will apreciate any
> >with the following issue:
> >
> >I need to build a configuration where the Firebird service runs on
> >HOST1 and the database files are on HOST2.
> >A mapped drive exists on HOST1 with full access to the path on
> >where the DB files are.
> >
> >I tried connection string with mapped path, UNC path and
> >also: "localhost://HOST1/FB/DATA/Data.fdb"
> >
> >Well, no go. I get message:
> >
> >Unable to complete network request to host "HOST1".
> >-Failed to establish a connection.
> >-The network name cannot be found.
> >
> >Same error from the program, Firebird ODBC and isql.
> >
> >All works fine, if DB files are on HOST1.
> Nope, sorry, you can't do it. The database file(s) and the
Firebird server
> must be on the same physical host and the network node must be a
> node with an IP address - no mapped drives, no shares.
> >I tried to change this setting in firebird.conf:
> >ExternalFileAccess = Full,
> >but it didn't help.
> That has nothing whatsoever to do with network configuration, read
> documentation in firebird.conf!!


Well, I did and although English is not my mother tongue (no one
writes documentations in Bulgarian, uh!), I think I understood the
following part fine:

# ----------------------------
# 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
# 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
# open a database only if the database is stored on a drive
# attached to the local computer â€" the computer running that copy of
# Firebird. Requests for connections to databases stored on NFS
# drives are redirected to a Firebird server running on the computer
# "owns" the disk.

"Unless this configuration option is changed from 0 to 1", means that
if changed to 1, the option should allow Firebird to "open a database
EVEN if the database is NOT stored on a drive physically
attached to the local computer"...

Am I getting this wrong?? Ok, I read all the warnings and I know what
the risks are.. I'll try to avoid this situation and use local DB
files. But, is this possible at all or the setting above is related
to something else?
If this is, however, possible what connection string should I use?