Page 1 of 1

Connecting to interbase file from remote location with IBCConnection?

Posted: Tue 17 Jun 2014 12:18
by Bjarke_Moholt
Hello DevArt!

I am trying to create an IBCConnection to a firebird database file on a remote location. However, I only have the name of the network share, and not the local file path.
\\server\sharename\database.fdb

My problem is I do not know how to configure my connection using the share name instead of the local path. I have tried using 127.0.0.1 on the server to get to the network share but I can't seem to get the syntax right. Can you help?

Re: Connecting to interbase file from remote location with IBCConnection?

Posted: Wed 18 Jun 2014 11:07
by PavloP
To create a connection to a database on a Firebird server, you should specify the local path to the database on the server in the TIBCConnection.Database property.
Using network share name won't let you connect.

Re: Connecting to interbase file from remote location with IBCConnection?

Posted: Thu 19 Jun 2014 10:31
by Bjarke_Moholt
In the TSQLConnection class out of your DBX package, it was possible to establish a connection using the UNC path. How can I do this with IBDAC? Did you remove the feature?

Re: Connecting to interbase file from remote location with IBCConnection?

Posted: Fri 20 Jun 2014 07:32
by Bjarke_Moholt
PavloP wrote:To create a connection to a database on a Firebird server, you should specify the local path to the database on the server in the TIBCConnection.Database property.
Using network share name won't let you connect.
As you never actually have the local path on a network share, does this really mean IBDAC doesn't support opening databases from a network share?

Re: Connecting to interbase file from remote location with IBCConnection?

Posted: Fri 20 Jun 2014 09:29
by PavloP
We couldn't establish connection in the way you have described. Please create a small test project that demonstrates the approach you have described, and send it to pavelp*devart*com.

Re: Connecting to interbase file from remote location with IBCConnection?

Posted: Wed 02 Jul 2014 11:37
by Bjarke_Moholt
A demonstrative test project was packed up and sent to the specified address last week, please confirm that the project has been received.

Re: Connecting to interbase file from remote location with IBCConnection?

Posted: Thu 03 Jul 2014 13:02
by PavloP
The approach you have specified is not connection using a UNC name, but a non-documented Firebird feature. To use this feature in IBDAC, set the TIBCConnection.Server property to an empty string.

Re: Connecting to interbase file from remote location with IBCConnection?

Posted: Thu 03 Jul 2014 14:48
by Bjarke_Moholt
Ok, now it works.

Simply enough :) Thank you

Re: Connecting to interbase file from remote location with IBCConnection?

Posted: Fri 04 Jul 2014 09:04
by PavloP
If any other questions come up, please contact us.