Can I run multiple Firebird Databases on the same network/PCs.
Posted on 2008-10-11
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.