LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How do i connect sql to labview??

may i noe how do i connect sql (mysql n mssql, is the connection method the same??) to labview?? cos currently my method is to save my readings to a .txt file... den i import it to my database... to save the trouble, i 1 2 connect directly to the database to cut down on the steps... may some1 help me??
 
thanx in advance... Smiley Very Happy
Best Regards,

JQ

LV 8.0 user...
0 Kudos
Message 1 of 7
(3,540 Views)

The connection is done through ODBC. In Windows, this is done through ActiveX or .Net. You need to define a connection to your DB (from Control Panel>>Administrative Tools>>ODBC Data Sources) and then you can access that connection from LV. To form the actual connection you can use LabSQL.

As for inserting the data into the DB, you need to use SQL, which is simple language for working with DBs. Depending on the structure of your database, it may be more or less complex to enter the data into it. Look up some SQL tutorials to learn more about it.


___________________
Try to take over the world!
Message 2 of 7
(3,530 Views)
oic... so its the same as using other software to connect to SQL?? i dun need any special library to connect to it?? kk... thanx.. i thot LV required a special library to connect to SQL.. i'll try it soon...
 
thanx a lot tst... Smiley Very Happy
Best Regards,

JQ

LV 8.0 user...
0 Kudos
Message 3 of 7
(3,529 Views)
If you want to access a MySQL DB, you'll need to install the MySQL ODBC driver. You can download it here.
Message 4 of 7
(3,525 Views)

There are several tools which already have VIs doing the interaction with the ADO objects needed for this, so there is no need to code that part again.

NI sells a toolkit, there's LabSQL which you can search for and I also remember seeing a tool on the LAVA forums (try searching for "ADO").


___________________
Try to take over the world!
Message 5 of 7
(3,522 Views)
LabSQL really works fine and it's for free.
Try it!

Message 6 of 7
(3,519 Views)
LabSQL... ok.. i'll go do a search later 2 find it... thanx all 4 ur help... Smiley Happy
Best Regards,

JQ

LV 8.0 user...
0 Kudos
Message 7 of 7
(3,516 Views)