Solved

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

Posted on 2008-10-11
4
541 Views
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.
0
Comment
Question by:Javier196
  • 2
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
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?

0
 
LVL 1

Author Comment

by:Javier196
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?
0
 
LVL 19

Expert Comment

by:NickUpson
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
0
 
LVL 1

Author Closing Comment

by:Javier196
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,
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS SQL GROUP BY 6 71
simple bash script needed to unpack tar.gz 4 25
Options for Linking SQL tables to Access 2013 9 30
Citrix App 7 24
For many of us, the  holiday season kindles the natural urge to give back to our friends, family members and communities. While it's easy for friends to notice the impact of such deeds, understanding the contributions of businesses and enterprises i…
I had an issue with InstallShield not being able to use Computer Browser service on Windows Server 2012. Here is the solution I found.
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

685 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