LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how do i connect my labview to query an sql server via IP

Hello, I am really new to SQL and database connection. I have access to a database via IP address. I currently use toad for sql server for the query. I would like to link labVIEW up to this server. The idea is to create functions to sorta "crawl" through the data looking for specific criteria. Any help would be greatly appreciated.

 

Thanks,

 

Travo

0 Kudos
Message 1 of 4
(4,234 Views)

To connect to SQL Server you will need to use either the Database Connectivity Toolkit or LabSQL. Either way you will need to use a DSN, UDL, or a raw connection string.

0 Kudos
Message 2 of 4
(4,217 Views)

Can you explain the difference between the two? I have the toolkit but don't know how to use it. are there any examples of the "how to". Do I create a VI? etc

 

Thanks 

0 Kudos
Message 3 of 4
(4,211 Views)

Labview has many examples on databases.  On the Labview splash screen, click on Example Finder.  In the search box, type in database and click search.  You will see several example vi's displayed.  You will also need to become familiar with SQL, see here

 

- tbob

Inventor of the WORM Global
0 Kudos
Message 4 of 4
(4,202 Views)