| Subject | [firebird-support] Connecting to database on remote server |
|---|---|
| Author | Rustam |
| Post date | 2019-07-08T10:40:56Z |
Correct connection string for 'remote' connection is:
<server>/<port>:<path to DB>
For 'embed' connection it is just
<path to DB>
In your case may be problems for Firebird client library with parsing string "\\FIREBIRDSERVER\E:\DB.FDB"
Client library can check if there is an drive "E:" - if there, then used 'embedded' mode with
direct file access to DB via network. If there is no drive "E:" - client decides to use a
'normal' remote connection, for which this is wrong: it parsed as server '\\FIREBIRDSERVER\E'
and path to DB as '\DB.FDB'.
For remote connection, when Firebird server service is located on \\FIREBIRDSERVER machine
your must use this connection string:
FIREBIRDSERVER:E:\DB.FDB
8 липня 2019, 13:19:50, від "Tony Christiansen tony@... [firebird-support]" <firebird-support@yahoogroups.com>:
Hi
I am running an app on my PC that connects to a database on my firebird
server FIREBIRDSERVER
The path is \\FIREBIRDSERVER\E:\DB.FDB
If my pc has an E: drive (ie I plug in a usb) I can connect to the database.
If my pc has no E: drive then I cannot connect to the database and get
the error - unable to complete network request to host "e"
Why does it matter what physical drives I have on my local machine? Is
this a quirk or design (I am no DBA expert)
Regards
Tony