2 Firebird servers on one PC/ Database inaccesible

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
werkstattboss
Posts: 20
Joined: Fri 15 May 2009 17:53

2 Firebird servers on one PC/ Database inaccesible

Post by werkstattboss » Tue 10 Feb 2015 08:26

Hello,
lately I installed a Calendar Program for testing. From that Moment on My Program (Delphi XE2 / IBDac latest Version) was not able to reach its Database (FB 2.53). The Error Message was something like "cannot open the File because another process has locked it". I discovered the second server when I tried to restsrt the Server Service.
After deinstalling the Calendar and thus the second Firebird server, everything worked fine.
The second FB Server was installed in an subdirectory of the installation Path of the program with the Name "Firebird Server - App Name" using the next free Port above 42000. It was running as a Service.

Is it possible that IBDac has an issue on identifying its server among others?
What (if) can I do to solve the Problem?

I was totally surprised of this.
Since we all want firebird to be used more in Development, this case may happen more often in Future.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: 2 Firebird servers on one PC/ Database inaccesible

Post by ViktorV » Tue 10 Feb 2015 13:45

This issue is most likely related to the specificity of the installed application, not IBDAC. You can ensure this by performing the following steps:
- delete the installed application;
- create 2 applications using IBDAC;
- run them and try to connect to your server.

werkstattboss
Posts: 20
Joined: Fri 15 May 2009 17:53

Re: 2 Firebird servers on one PC/ Database inaccesible

Post by werkstattboss » Tue 05 Apr 2016 12:59

The Problem is simple to solve.
The Issue is that there are 2 FB Server Instances, one 32 Bit and one 64 Bit.
Firebird seems to "fall back" to 32 Bit access when there is a 32 Bit Database server running.
So the 64 Bit FB Server is not accessible anymore.

All the Firebird Servers on a Machine must have the same Data width (32 or 64 Bit).

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: 2 Firebird servers on one PC/ Database inaccesible

Post by ViktorV » Wed 06 Apr 2016 05:37

It is good to see that the issue has been solved. Feel free to contact us if you have any further questions about IBDAC.

Post Reply