Go Premium for a chance to win a PS4. Enter to Win


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
  • 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 Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

If you’re involved with your company’s wide area network (WAN), you’ve probably heard about SD-WANs. They’re the “boy wonder” of networking, ostensibly allowing companies to replace expensive MPLS lines with low-cost Internet access. But, are they …
This article explains the fundamentals of industrial networking which ultimately is the backbone network which is providing communications for process devices like robots and other not so interesting stuff.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), 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 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.…

926 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