TN - LVS-95xx Software v4.6.0.3007- Fatal SQL Connection Error

Summary/Issue Description

There is a known issue that can crash the LVS software during setup of an SQL Server database connection or if upgrading the LVS software to version 4.6.0.3007 with an existing SQL server database connection.  Below is the error that will be thrown and crash the software.

Root Cause

This issue seems there is a syntax issue where the update statement programmed into the software needs to be different in the SQL database than it is in the MDB SQL environment. 

Solution

1. Update the LVS software to version 4.6.0.3007.
2. Download the attached file, "Updates.sql".
3. Place the Updates.sql file into the following location C:\Program Files (x86)\Microscan\LVS-95XX and replace the existing file in the destination. 
4. Open the LVS-95xx software.

Date/Revision History

Published 2/18/2025 V1.0

Author:

Anthony Rosario - Technical Support Specialist

References

This issue has been submitted as a bug to engineering. Jira case LVS-1121.