Example Program Drafts

Showing results for 
Search instead for 
Did you mean: 

Insert Data into DataBase from an Array using LabVIEW Database Connectivity Toolkit LV 8.6


This VI inserts data into a database from an array in LabVIEW using the Database Connectivity Toolkit.


  1. Uses a UDL file to open a connection to the desired database.
  2. Take the array information which you want to insert into the database and extracts the columns which you wish to insert.
  3. Opens a connection to the Database, inserts the data into the database, and closes the connection to the Database.

Steps to Implement or Execute Code

  1. Select the UDL file for the connection information to the desired database
  2. Set the desired Table Name and Columns
  3. Write the Data to insert into the Database in the Array
  4. Run this VI

Requirements to Run


LabVIEW 8.6 or Later



Additional Images

Block Diagram

insert data into DataBase.JPG

Additional Information

Use the DATABASE CREATION PROCEDURE.pdf available on http://decibel.ni.com/content/docs/DOC-4602

Salvador Mikel
National Instruments
Ingeniería de Aplicaciones
Member parii

i do it but it shows error..no of coloumns does not equals to parameter .what does it means

Active Participant ijustlovemath
Active Participant

Perhaps you should see if the number of columns you're inserting is equal to the number of parameters you're inserting.