Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Can I run multiple Firebird Databases on the same network/PCs.

Posted on 2008-10-11
Medium Priority
Last Modified: 2013-12-09
My office runs a homegrown program that runs the POS at our stores, our accounting, our inventory, shipping/receiving, etc.  This database runs using Firebird database 2.1 as the database engine.  It utilizes port 3050.  The main database resides on a HP DL380 running Windows 2K3 Server.  All the clients are Win XP Pro PCs.  The PCs have Firebird installed locally, but the company database is accessed via a mapped drive.

I tried to implement a Web Blocking program that, you guessed it, runs on Firebird database 2.1.  I found this out the hard way.  The web blocking program, BrowseControl, utilizes ports 8998 and 8999 for the web-blocking portion, but the database utilizes port 3050.  The Web blocking control software and database is installed on a different machine, a beefy XP Pro machine.  I installed the BrowseControl client on a few systems as a test, and all seemed fine till my developer called me and told me the Firebird service on the main fileserver stopped.  When I looked over the BrowseControl documentation, I found out it also used the Firebird database.  I de-installed the BrowseControl clients, and we restarted Firebird on the main fileserver.  All came up fine.

My question.  Can I run these two programs on the same network?  I have already bought all the licenses, and I would like to be able to utilize the BrowseControl program.  I know I can change the port of our company program to run on something other than port 3050.  My question has to do with the client PCs.  Can I run multiple databases using Firebird on the Win XP Pro PCs?  I would run BrowseControl on port 3050, and our company software on another port.  I just dont know if I can run each of the programs on the users PCs at the same time.  I have no experience with Firebird, and my developer just moved over to this database recently, so I was aware of he change.

Thank You in Advance.
Question by:Javier196
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 19

Accepted Solution

NickUpson earned 2000 total points
ID: 22697877
The company database cannot be accessed via a shared drive as firebird specifally does not allow this, the database should not even be visible on the network, but to answer your question.

"Can I run multiple databases using Firebird on the Win XP Pro PCs? " I don't think this is actually the right Question. It should be

can I run both products on the same network, yes absolutely, from the same client PC's, yes easily if they use the same version of firebird, which you say they do.

As described there is not even a need to change the ports used as the communications unless you have both products on the same server - then this would be necessarry, it would also need one to be installed in a non-default location as their security databases would get overwritten

The part that has me puzzled is that you installed the webblock s/w on some PCs and the firebird s/w on the server stopped working, could it be that the web cloocking software was blocking the firebird traffic on the entire network?


Author Comment

ID: 22703682
Just to Clarify.  The sytem we run utilizes a local Firebird database on their PC on the back end.  Our homegrown program then updates the central database on the front end via the mapped drive.

The web blocking software is installed on a different system than our company database.  Originally, our homegrown software was using IB Server, but was recently migrated to Firebird.  I thought they should be able to coexist since they utilize differnet sockets.  But it could be that the web blocking software may see our company database as some sort of threat and somehow caused the service to shutdown on our fileserver.

I am going to test again and see if it was a fluke, or if their is indeed a conflict.  It is difficult since the whole company runs this program.  If there is a confiict, would changing the port on our company database help, and if so, how would I have to configure Firebird on the PCs to support each program?
LVL 19

Expert Comment

ID: 22704880
to change the port that the client software uses you need access to the source code, the connection string need to be something like myserver::c/data/db.fdb:13050 making the port 13050), you also need to edit the firebird.conf file and set the listen address to the same port. Changes to the file are not used until firebird next starts running, if unsure, reboot the machine

Author Closing Comment

ID: 31505335
I believe the problem was a fluke.  Our company database stopped running at the same time I deployed the first PCs.  We were making a number of changes in the network and to the database, but I wanted to make sure I could run both at the stame time.  

I have since deployed the web blocking software and all is fine.  

Thank You,

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

WARNING:   If you follow the instructions here, you will wipe out your VTP and VLAN configurations.  Make sure you have backed up your switch!!! I recently had some issues with a few low-end Cisco routers (RV325) and I opened a case with Cisco TA…
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question