Installing VETtrak and Configuring the Database (Local)

Nick Jones

Modified on: Tue, 14 May, 2024 at 4:04 PM

The VETtrak Installation file comes with everything you need to set up, and start using a new VETtrak installation - Including the Microsoft .NET Framework version VETtrak requires, and an optional installation of the Firebird Database Software if you intend to make use of it.

To install a new copy of VETtrak, you must first visit our VETtrak Support Centre, and download the installation file from the Downloads area, titled VETtrak Installer for new customers:

Once the download has finished, you can minimise or close your browser, find the VETtrak Installer File, and double click to open:
The VETtrak installer will show several button options:
1. The first button is the VETtrak software itself.
2. The second button is the Microsoft .Net Framework that VETtrak uses for essential services.
3. The final button, is the Firebird Database Software. This is an essential piece of software that VETtrak uses to talk to its database. At this point, if you make use of Microsoft SQL server, you can instead utilise that for VETtrak’s database needs, and can therefore ignore the option to install
Press the Install VETtrak button to begin the installation of VETtrak software. This will open a specific window that guide your through this process.

You can choose to do a ‘Typical’ installation, or a ‘Custom’:
1. The Typical installation will simply place VETtrak on your ‘C:’ drive, so your VETtrak location will be C:\VETtrak\
2. The Custom installation will allow you to configure a few options, most importantly which folder VETtrak will install to.
  
  It is recommend to use the ‘Typical’ installation as it guarantees that the VETtrak folder is easy to locate should you require.
Press Install to begin the process; VETtrak should only take a moment to install, and once completed you can press the ‘Finish’ button to close this window, and return to the VETtrak install suite.
The next step will involve installing the Microsoft dot NET framework.
You may find that when you push this button, it may advise it is already installed, if this is the case; simply ignore this step and move on.

Pressing the dot NET button should prompt an installation window to open - Proceed through the windows, leaving items as default until it completes.
Finally, we require to install the Firebird Database.
If you are intending to, or already use Microsoft SQL server, feel free to bypass this process.
Simply press the Firebird button for the process to complete itself automatically – Nothing needs to be configured, as Firebird will simply run as a background service, allowing VETtrak to communicate with the database.
Once this done, you have completed the initial installation procedure, Feel free to close this installation suite by tapping the [X] in the top right hand side, and if you wish you can now delete this file as it has served its purpose.
With this completed, you should now have all the resources required for a full working copy of VETtrak on your computer of choice – Which can now be accessed by the VETtrak icon available on the desktop:
Double-click on the icon to start VETtrak. The following message will be displayed:
Press Ok to display the VTConfig window, allowing you to configure your Database, depending on the database platform you have set up.

Database Platform Set Up

There are two options for database engines for VETtrak:

Firebird - This is a free, open-source database engine, which is supplied with the VETtrak Installer. Use this if you are not using Microsoft SQL Server.
Microsoft SQL Server - If you have an existing Microsoft SQL Server environment, you may run a VETtrak database on it.

Setting up your Firebird database

If you intend to use Firebird, make sure that Steps 6 & 7 of the installation process is completed - this will set up the Firebird program to run as a service on the machine, allowing the VETtrak Database to communicate with the VETtrak software.

The VETtrak database file will be located in the VETtrak\Data folder, and by default is titled VETtrak.gdb

Setting up your Microsoft SQL Server database

If you wish to use Microsoft SQL Server, you will need to have Microsoft SQL Server installed and set up correctly on your database server.

As Microsoft SQL Server is an involved piece of software, we recommend that any Help Resources you make use of come from a reliable source, such as the Microsoft technical documentation website.

To configure your VETtrak SQL Database:

Create a database for VETtrak within the Microsoft SQL Server application.
Copy the VETtrak.bak file from the VETtrak\Data folder once the VETtrak installation has been completed, and restore it into the new VETtrak database in Microsoft SQL Server.
Grant the appropriate user(s) dbo access to the VETtrak database in Microsoft SQL Server.

VETtrak Configuration (Firebird)

Firebird is set. Do not change this.
Firebird is required to be selected here. Do not change this.
Default path and name for the database is shown in this field - These details may require changing depending on how your local machine is configured.
Press Test Now! to test the database connection.
Click Finish.

For more details on the additional options within the VTConfig Tool, please view our article here: VTConfig Overview

VETtrak Configuration (Microsoft SQL Server)

Select Microsoft SQL Server.
Set the name of the SQL server.
Set the name given to the VETtrak SQLServer database.
If you are using SQL authentication, set the Username and Password corresponding to the SQLServer login. If you are using Windows authentication, tick the provided box.
Press Test Now! to continue.
Click Finish.