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

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
  • 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

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

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

Suggested Solutions

When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

838 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