From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

Example Code

Create UDL File - SQL Database Server V 1.0

Products and Environment

This section reflects the products and operating system used to create the example.

To download NI software, including the products shown below, visit ni.com/downloads.

    Software

  • LabVIEW

Code and Documents

Attachment

Overview

This Example will create UDL file for SQl Database server. Also you can create database using this example.

 

Description

This Example will create UDL file for SQl Database server, using LabVIEW Database Connectivity Toolkit.

Also you can create database using this example.


Requirements

  • LabVIEW 2012 (or compatible)
  • Database Connectivity Toolkit (or compatible)

 

Steps to Implement or Execute Code

  1. Run the VI.
  2. Select the way of logging on to server.
  3. Click on OK button to check connection.

 

 Additional Information or References  

 Front Panel

Create UDL.png

 

Block Diagram of top level VI (Create UDl_SQL 2012.vi)
1.png

 

2.png

 

Update - Uploaded for version 8.2, 8.5, 8.6, 2012

Please give your comments

 

Regards

Prabhakant

 

 **This document has been updated to meet the current required format for the NI Code Exchange.**

Regards
Prabhakant Patil

Example code from the Example Code Exchange in the NI Community is licensed with the MIT license.

Comments
Gyc
Member
Member
on

Hi. The link for download of LV8.6 version is broken.

Prabhakant_Patil
Member
Member
on

Please click on like if you like it.

Your valuable suggestions are always welcome for the improvement.

Regards,

Prabhakant

Regards
Prabhakant Patil
NishantPatel
Member
Member
on

Dear Mr Prabhakant,

This set of files is a sizeable contribution.

Keep up the good work.

SKant
Member
Member
on

Hi Prabhakant,

Thanks for uploading your valuable code.

Here I find a problem that BD is password protected. I wanted to modify some code as per my requirement but I am stuck here due to password protection.

Could you provide the password.This will very helpful for me.

jayanthan
Member
Member
on

sir

     i am student .i need read &create table in microsoft sql server 2008 r2 using labview.please help me.this is for mycollege  project

Gyc
Member
Member
on

Search on the NI community and lavag.org.

https://decibel.ni.com/content/docs/DOC-4603

https://decibel.ni.com/content/docs/DOC-4661

Also check  http://jeffreytravis.com/lost/labsql.html  for a freware alternative to NI Database toolkit.

I have been using it for lomng time. It works!

leonidas.mauricio
Member
Member
on

Hello Prabhakant,

Your admirable code is very helpfull. I was wondering if could you  give us a password protection please. Because I would like to see some details.

Thank you.