How to Connect LabVIEW to a Database

Issue Details

I need to connect my LabVIEW application to a database to store and query measurement data and configuration information. What is the simplest way to do that using LabVIEW?

Solution

The best and easiest way to perform database connection and operations in LabVIEW is by using the LabVIEW Database and Connectivity Toolkit. This comes with a simple API that allows for the creation of routines that work with the most popular databases. These include:

• Microsoft Access
• SQL Server
• Oracle

The Database and Connectivity Toolkit also provides a set of advanced functions to access low level operations.

Sample code that exemplifies the usage of this Toolkit can be found below. This is a native example that comes with the Toolkit, and can be found by clicking Help>> Find Examples >> Toolkits and Modules >> Database Connectivity.


Note: This image is a LabVIEW snippet, which includes LabVIEW code that you can reuse in your project. To use a snippet, right-click the image, save it to your computer, and drag the file onto your LabVIEW diagram.

Additional Information

Alternatively, the 3rd party LabSQL VIs can be used to establish a connection with a database in LabVIEW.
Note: NI is not responsible for LabSQL and does not offer technical support for it's use.