Subject Re: [firebird-support] Remote Database files
Author Helen Borrie
At 01:03 AM 16/11/2005 +0000, you wrote:
>I am not very experienced with Firebird and I will apreciate any help
>with the following issue:
>I need to build a configuration where the Firebird service runs on a
>HOST1 and the database files are on HOST2.
>A mapped drive exists on HOST1 with full access to the path on HOST2,
>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 physical
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 the
documentation in firebird.conf!!

>Is this configuration possible at all,

A big NO.

Do yourself a favour and grab the Quick Start Guide from the Resources area
of the Firebird website.