Firebird Database Server
|Top Previous Next|
Note: the remote database features described in this section are for the "Fleet Network Edition" only. The other editions (Home, Professional, Fleet) do not have the remote database feature available.
When you install the Vehicle Manager client software on your computer, an embedded database is installed by default to allow you to try out the software without further configuration. However, when you're ready to share the software on a network with multiple users, you need to install a shared database on a server. Any Windows computer may act as the database server, as long as it is accessible from all of the computers which need to access the shared database. You also want to make sure the computer is able to run without interruption to avoid any potential for database corruption which might occur if the computer is restarted while users are connecting to and using the database.
There are three basic configurations to choose from. Click on a diagram below to view full size:
Each of the configurations require three basic steps:
You may watch a 3 minute instructional video, or follow the steps below:
The client software is the program that users interact with to enter and update Vehicle records. If you have used the trial version of Vehicle Manager, then you have already installed at least one copy of this software. This software is available for download at:
Note that in order to connect to a shared database server, you must install the "Vehicle Manager Fleet Network Edition". All editions of Vehicle Manager start in single user stand-alone mode by default. The "Vehicle Manager Fleet Network Edition" can also connect to a remote central database server.
The database server software is very easy to install in the default configuration. To install in the default configuration, follow these steps:
If you are using the Windows Firewall, configure it to allow Inbound TCP connections on Port 3050 as described below:
For Windows Server 2008, and later (2012, 2016, 2019):
For Windows Server 2003 and 2000:
After installing the database server, connect your client computer(s) to the shared database server by following these steps:
Note: If you cannot connect to the database server, please see the following section: Troubleshooting Connections.
When you're finished configuring the database connection, set up a scheduled task to backup the database daily.
Advanced - Database File Storage:
If you are a server administrator and would like to change the default location where the Vehicle Manager database is stored, you may do so by following the instructions below. Vehicle Manager is designed to run with the standard options "out of the box", and in most cases there is no reason to change the defaults; however, these instructions are provided for server administrators who would like to change the default installation.