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

Posted on 2008-10-11
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 500 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
This article is in regards to the Cisco QSFP-4SFP10G-CU1M cables, which are designed to uplink/downlink 40GB ports to 10GB SFP ports. I recently experienced this and found very little configuration documentation on how these are supposed to be confi…
Internet Business Fax to Email Made Easy - With  eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor ( Top Charts is a view in which you can set seve…

615 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