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 ...

• Add and Maintain SQL

  To add a new custom report you need to tell VisitorRego how to retrieve the data from the database and how to format this data in a report. Open the Custom Reports screen. Note: Before you edit the SQL you need to know the database engine used - ...

• 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 ...

• Step 2 - SQL Update

  Some upgrades may require changes to the database. If you are using a Microsoft Access database... Sit back! Relax! Your database will automatically update when you install with the new version. If your database is being held on an SQL server, then ...

• Adding an Additional Field to the Label

  Adding an additional field to the visitors label for example, car registration, can be edited in Visitor Rego. Navigate to Options > Registration setup to find the database field. The database field for car registration is called‘Vehicle’. Navigate ...