firebird c# connect to a remote db

Question

I am working on some existing project and I am trying to make it go from many firebird databases on the client end to one server based database.

Unfortunately I am having some trouble with the connection string.

Is it possible to connect to a .fdb file on a remote server?

Currently the code is as follows:

var builder = new FbConnectionStringBuilder
        {
            Database = @"C:\test.db",
            ServerType = FbServerType.Embedded,
            Pooling = isPooled
        };

I have read some examples about how it can be done like the below but its not working:

FbConnectionStringBuilder(@"Database=192.168.1.235:C:\share\test.fdb;User ID=sysdba;Password=masterkey;")

It still connects to just the local directory C:\share\test.fdb. As that is not my ip address. Any help?

Mark Rotteveel · Accepted Answer · 2013-02-13 08:46:30Z

2

The Database property is only for the database filename or alias, you need to use DataSource for the hostname or IP address and Port for the Firebird port. Check out .NET — Examples of use and Connection string parameters

Also the class FbConnectionStringBuilder is intended to simplify building a connection string (it has properties for the various connection string properties), so your first use is correct, but the second use is a bit odd.

answered Feb 13, 2013 at 8:46

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1434177 · Accepted Answer · 2013-02-14 21:13:12Z

0

Ok so I think I worked it out. You cannot access an embedded database remotely. So once the server software was installed and this was removed it all worked fine. Would be a handy feature to connect to it on a remote drive but ohh well.

answered Feb 14, 2013 at 21:13

user1434177

1,9774 gold badges27 silver badges41 bronze badges

Comments

bratsche · Accepted Answer · 2015-12-26 21:32:41Z

0

Be sure fireBird is listening on port 3050, uncomment this lines in firebird.conf

RemoteServiceName=gds_db
RemoteServicePort=3050

restart the service.

edited Dec 26, 2015 at 21:32

bratsche

2,66421 silver badges24 bronze badges

answered Dec 26, 2015 at 20:47

Guillermo R. P.

1

Collectives™ on Stack Overflow

firebird c# connect to a remote db

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related