TG - LVS-95XX – SQL Server Database Connection Setup

Purpose

The purpose of this guide is to provide basic instructions on how to change the LVS-95xx software to switch from using the default local MS Access database to a SQL Server database.

Problem Explanation/Objective

As there are many different types of SQL database applications, it is not possible for Omron Microscan to test against all such applications.  Omron Microscan cannot guarantee compatibility with your SQL Server.

Switching to a SQL server database will only work when switching from the default LVS Microsoft Access database file.  Switching from a SQL server database to another SQL server database is not possible.   To switch to a new SQL server database, you will need to revert to the default MS Access database file and repeat the following LVS-95XX software setup instructions.  See the Notes at the end of this document.

Supported devices

List of devices, hardware, or software that are compatible or relevant to this guide.

• LVS-95xx Software
• LVS-9510
• LVS-9570
• LVS-9580
• LVS-9585

Requirements

You will need the LVS-95xx software and one of the following devices. 

• LVS-9510
• LVS-9570
• LVS-9580
• LVS-9585

Procedure

Set up on the SQL server: 

1. Create a new Database: LVS-95XX 
2. Create a new User: LVS-95XXAdmin 
3. Grant new User (LVS-95XXAdmin) full access to Database (LVS-95XX).

Example only. Your values will be different depending on your SQL installation. Consult with your SQL administrator for assistance setting up your environment. 

Set up in the LVS-95XX software:

1. In the Archive tab, click “Change SQL Connection”. 
   
    
   
   
   
2. Then, Click the “Change ODBC Connection String to use MySQL” button. This will work for any SQL connection. 
   
    
   
   
   
3. Enter the connection string to connect to your SQL Server database and click the Ok button. 
   
    
   
   
   
4. You will be asked to populate the SQL server database file with LVS-95xx information. This data must be copied over or the LVS system will not work.  Click the “Yes” button to populate the SQL server database with the necessary information. 
   
    
   
   
   
5. You will then be asked if you want to copy over all of the settings and reports from the current database file.  This step is optional.  
   
    
   
   
   
6. You will then be asked to update the registry console.   This registry change will need to be allowed to change in order for the Database connection to change.  Click the “Yes” button to continue.  The connection will switch over to the SQL server database and take effect immediately. 
   
    

Date/Revision History

Published 2/13/2025 V1.0

Author:

Anthony Rosario - Technical Support Specialist

References

Note: After you have changed the SQL Connection string in the Archive Tab.  The LVS-95XX software will immediately switch to the SQL database.  The previous Microsoft Access database file will still be located at C:\Users\Public\LVS-95XX.