Internship: Implementing Robust SQL Database Connectivity in a LabVIEW Test Framework

Subject: Implementing Robust SQL Database Connectivity in a LabVIEW Test Framework

Background

:Our existing test framework is built in LabVIEW and relies on an SQL Server database for data storage and retrieval. Because the framework is often used in environments with Wi-Fi connections, temporary network interruptions can occur. These interruptions currently lead to unwanted effects in the test application, such as failed queries or potential data loss. To ensure reliable operation, the framework must be extended with functionality that can detect connection loss, automatically re-establish the connection, and guarantee that pending queries are preserved and executed correctly

.
Task Descriptio

n:The intern will design, implement, and validate a functionality for the existing LabVIEW-based test framework that makes the SQL database connection robust against temporary network interruptions. This includes developing mechanisms t

• o:Detect network connection los
• s.Reconnect automatically to the SQL server once the network is restore
• d.Ensure that queries and data transactions are not lost or corrupted during reconnectio
• n.Investigate options for buffering communication during connection los

s.Key Objective

s:
Analys

• is:Investigate how SQL connectivity is currently managed within the FTF framewo
• rk.Identify failure scenarios that occur during connection lo

ss.
Design & Implementat

• ion:Propose and implement a mechanism in LabVIEW that ensures stable database interact

ion.
Valida

• tion:Simulate network interruptions and test the robustness of the new functiona
• lity.Verify that no data loss, duplication, or corruption occurs when so

lved.
Document

• ation:Deliver clear technical documentation describing the implemented solution, usage, and limita
• tions.Provide recommendations for further improvements in database connection han

dling.Expected Ou

tcome:An proven solution that can handle temporary network disconnections gracefully, automatically reconnect to the SQL server, and guarantee reliable execution of database queries without data

loss.
Required

• Skills:IT technology background with knowledge of networking and dat
• abases.Skilled in SQL databases (preferably SQL S
• erver).Programming knowledge, with interest in LabVIEW devel
• opment.Analytical and problem-solving mindset and interest in handling error recovery and data int

egrity.
Is this interesting for you? Do not hesitate an