Hi Rustam

Where is an explanation of the different connection strings.

I am using a TIBDatabase in Delphi
With databasename property set to \\FIREBIRDSERVER\E:\DB.FDB it connects
With databasename property set to FIREBIRDSERVER:E:\DB.FDB it does not connect with error  unable to complete network request to host "FIREBIRDSERVER"

My environment is windows and without the \\ the client cannot find the host.

Thanks for your assistance
Tony

 

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