Connecting to interbase file from remote location with IBCConnection?

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Bjarke_Moholt
Posts: 39
Joined: Thu 21 Nov 2013 12:51

Connecting to interbase file from remote location with IBCConnection?

Post by Bjarke_Moholt » Tue 17 Jun 2014 12:18

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?

PavloP
Devart Team
Posts: 149
Joined: Fri 24 Jan 2014 12:33

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

Post by PavloP » Wed 18 Jun 2014 11:07

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.

Bjarke_Moholt
Posts: 39
Joined: Thu 21 Nov 2013 12:51

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

Post by Bjarke_Moholt » Thu 19 Jun 2014 10:31

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?

Bjarke_Moholt
Posts: 39
Joined: Thu 21 Nov 2013 12:51

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

Post by Bjarke_Moholt » Fri 20 Jun 2014 07:32

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?

PavloP
Devart Team
Posts: 149
Joined: Fri 24 Jan 2014 12:33

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

Post by PavloP » Fri 20 Jun 2014 09:29

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.

Bjarke_Moholt
Posts: 39
Joined: Thu 21 Nov 2013 12:51

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

Post by Bjarke_Moholt » Wed 02 Jul 2014 11:37

A demonstrative test project was packed up and sent to the specified address last week, please confirm that the project has been received.

PavloP
Devart Team
Posts: 149
Joined: Fri 24 Jan 2014 12:33

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

Post by PavloP » Thu 03 Jul 2014 13:02

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.

Bjarke_Moholt
Posts: 39
Joined: Thu 21 Nov 2013 12:51

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

Post by Bjarke_Moholt » Thu 03 Jul 2014 14:48

Ok, now it works.

Simply enough :) Thank you

PavloP
Devart Team
Posts: 149
Joined: Fri 24 Jan 2014 12:33

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

Post by PavloP » Fri 04 Jul 2014 09:04

If any other questions come up, please contact us.

Post Reply