Connecting to a Database

Connecting to a Database

Finding the location of, and connecting to your VisitorRego database can be done via the Database tab.

To access this, from VisitorRego's Admin mode, choose Options> System Setup> Database tab.
 

 


Under the Databases tab there is a field labelled 'Database Engine' which is used to switch between the two database modes; SQL and Microsoft Access.
 

Choosing either of the two will automatically show the options associated with each one.


Microsoft Access

 

This is the default setting. VisitorRego is distributed with a local Access database for ease of install and trialling the software.

The Path of VisitorRego.mdb  shows the location of this database file.


SQL using Windows Authentication

SQL is the preferred database engine. If the company doesn't already have an SQL server, then SQL Express can be downloaded and installed free from Microsoft.

Note: you can only use an SQL database if you are running VR - Professional.


SQL using SQL authentication


Many companies are concerned with security, especially connecting a workstation to their network that is used by the public. If this is the case the workstation used by the public can be cabled to the network but authenticate against the domain. VisitorRego can then access the SQL database on a back end server within the domain and it only authenticates against this server using SQL authentication.




Changing databases requires VisitorRego to close the current connection and reopen the new connection. Click 'Apply' to make the changes to the configuration file. When the System Setup screen is closed is the time when the new database connection will be opened. 

It is good practice when ever changing a configuration setting, to stop and start VisitorRego The changes are only written to the configuration file when VisitorRego is stopped.

    • Related Articles

    • On-Network Database Integration

      Maximise data security and internal control by integrating VisitorRego with your on-network SQL server through our On-Network Database Integration feature. This configuration establishes a centralised database for all VisitorRego units within your ...

    • Choosing Your Site

      After installing VisitorRego or connecting a site to VRP, it is important to choose your site so that the software functions correctly. In most cases, after connecting a site to VRP and restarting the software, it will detect the site mismatch and ...

    • System Setup

      The System Setup option is the centralised hub for turning features in VisitorRego on or off and setting up functions. From VisitorRego's Admin mode choose Options> System Setup. System Setup option is the centralised hub for turning features in ...

    • Editing the Email Template

      The email notifications are all templates which reside in the Res folder of each machine. You can edit the response and save it, so the updated version is now the new email template. The file path for the template you are wanting ...

    • Self Registration Fields Setup

      As different companies require different sets of information from their visitors, VisitorRego has the ability to change what fields it displays on the Self-Registration screen. These fields can be configured on the Self Registration Fields window. ...