11-09-2014 10:19 AM
I use LV Database Toolkit, which by default uses Jet database. Now I want to use SQL database with LV Database Toolkit. I have downloaded and installed "SQL Server 2014 Express with Tools" in my Labview Laptop. Now I want to create a database in SQL Server, because I think it is a requirement for creating a "udl connection file" (*.udl file). Please help me!
Solved! Go to Solution.
11-09-2014 10:50 AM
11-09-2014 01:27 PM
11-09-2014 09:41 PM
Creating database does not require UDL. UDL is needed to connect to the SQL server with LabVIEW. UDL file created will have server name and credentials required to connect to SQL.
You can create database using queries fired from LabVIEW or you can go to SQL management studio and create a database and tables inside the database (With few right clicks and selecting appropriate options).
once database is created, then using queries you can do what ever you want.
11-10-2014 10:54 AM
Thanks to all who have devoted their Time! I have read all the sugestions and attachments, but I have still not tried anything to resolve my Issue. I have found 2 Articles on Microsoft Developer Network (which I have attached). The first one creates a database through "SQL Server Management Studio", which I will give a first try,if it is applicable to my case. The second is to run a Querry ("CREATE DATABASE TestData") from "LV Database Toolkit" That is supposed to create a database in SQL Server with the name "TestData"; I will give it a second try. Please keep on helping me further.
Thanks Again!
11-11-2014 11:41 AM
Hi!
In the last post I attached 2 Word 2013 document which can not be opened from previos versions of Word; so I am replacing with a website link of the 2 Articles.
SQL Management Studio: http://msdn.microsoft.com/en-us/library/ms186312.aspx
Create Databse through Querry: http://msdn.microsoft.com/en-us/library/ms365340.aspx
Please keep on helping me, because my issue has not made any substantial progress.
Thanks!
11-11-2014 01:03 PM
11-12-2014 01:09 AM
I am thankful for the feedback of all the contributors. After reading all the sugestions and attachments in this thread, it is now to me completely clear how to make the database in SQL Server and then it is also clear to me, when I have the name and Path of my database, how to make the udl connection file. When these 2 things are done, I will be able to use SQL database instead of Jet database with LV database connectivity Toolkit. As soon as I have done this, I will post it.
Thanks for all the feedback!
11-12-2014 01:52 AM
@khurshe wrote:
I am thankful for the feedback of all the contributors. After reading all the sugestions and attachments in this thread, it is now to me completely clear how to make the database in SQL Server and then it is also clear to me, when I have the name and Path of my database, how to make the udl connection file. When these 2 things are done, I will be able to use SQL database instead of Jet database with LV database connectivity Toolkit. As soon as I have done this, I will post it.
Thanks for all the feedback!
In labview go to tools -> create data link. ensure after cofiguring you should able to do test connection successfuly
11-13-2014 03:16 PM
I made a database whose path is: C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\depot1
I tried to make .udl connection file, but when I click on "test connection" with the provider: "OLEDB Provider for Microsoft SQL Server" I get the Error "UDL Connection File Failure" (attached below)
When I tried to make the .udl connection file with the provider "Microsoft SQL native Client 11.0" and when I click on "Test Connection" I get the Error" UDL Native Client_1"& " UDL Native Client_2".
Please help!
Thanks!