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.
2 Firebird servers on one PC/ Database inaccesible
-
- Posts: 20
- Joined: Fri 15 May 2009 17:53
Re: 2 Firebird servers on one PC/ Database inaccesible
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.
- delete the installed application;
- create 2 applications using IBDAC;
- run them and try to connect to your server.
-
- Posts: 20
- Joined: Fri 15 May 2009 17:53
Re: 2 Firebird servers on one PC/ Database inaccesible
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).
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).
Re: 2 Firebird servers on one PC/ Database inaccesible
It is good to see that the issue has been solved. Feel free to contact us if you have any further questions about IBDAC.