Contents
 Welcome
 Common Terms
    Terms
 Quick Start
    Pre-Installation
       .NET Framework
    Quick Install
    First Visitor
    Leaving
    Emergency
 Getting Started
    How to Get Support
    Online Information
    Implementation Options
 Setup and Maintenance
    Data - Company Specific
       Maintain Site
       Maintain Departments
       Maintain Staff
          Loading Staff – Active Directory
          Loading Staff – Excel
    Data - Visitor Specific
       People
       People - navigating
       Visitors Company
       Visitors Company - navigating
       Register
       Register - navigating
    Registration Screen
       Registration Setup
       Field Description
       Placing Fields
       File Locations
    Communication
       Email Notification
    Connecting and Installing Peripherals
       Printer Label
       Printer Plain Paper
       Label Printer Maintenance
       Scanner
          USB Mode
          Serial Mode
          Bar Code
       Webcam
    Setting up Database
       Creating the SQL Database
       Connecting to Database
 Self Registration
    Self Registration Setup
    Registering
    Customizing Graphics
    Features
       Tuning Features On or Off
 Messaging
    Broadcast Message Setup
    Individual Message Setup
 Report Builder
    Label editor
    Data Fields
    Objects
       Properties
 Custom Reports
    Adding a Custom Report
    Add and Maintain SQL
    Pre Defined Custom Reports
       Appointments
       Safety Induction Expiry
       Supplier Summary
       Supplier Summary - Detail
       Supplier - By Rep
       Visitor by Company
 Appointment/Pre Registration
    Make an Appointment
    Appointments
 Contractors
    ID Printer Setup
    Issue Pass
    Pass Template
    Safety Induction Enabled
    Entering Safety Induction
    Entering Safety Induction - Alternative
 Advanced Features
    Select Data to copy to Excel
    Paste data to Excel


LinkIndexBookmarkPrint
Home > Setup and Maintenance > Setting up Database > Connecting to Database

Connecting to Database 

Switching between databases in VisitorRego.NET can be done via the System Setup window accessed from Options>System Setup under reception mode. Note you can only use an SQL database if you are running VR - Professional.

 

Once under System Setup navigate to the 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 ether of the two will automatically show the options associated with each one.

Microsoft Access. This is the default setting. VisitorRego.NET is distributed with an Access database for ease on install and trialing the software.:



SQL using Windows authenticatioin.

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.



SQL using SQL authentication.

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



Changing databases requires VisitorRego.NET 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 every changing a configuration setting, to stop and start VisitorRego.NET. The changes are only written to the configuration file when the VisitorRego.NET is stopped.
See also
Creating the SQL Database



  

  
Article Details
Created:5/02/2010 11:17:46 a.m.
Modified:3/05/2011 12:58:48 p.m.
Author:Admin
Views:34

Options
 Print Article
 Bookmark Article
 Link to this Article

Related Articles
  
To add links, place the cursor in the box above and then click 'Link Page' on the toolbar.

File Attachments
  
To upload and insert attachments, place the cursor in the box above and then click 'Document Manager' on the toolbar.