How to communicate with SQL using LabVIEW 7.1...?

[Rupali]

Hello...

       I want to create a system which deals with database & stores the database in server through SQL... Can anyone please guide me how to communicate with SQL using LabVIEW 7.1...?

       Thanks for any help from you..

[AdnanZ · Accepted solution]

You can either use LabVIEW Database Connectivity Toolkit or LabSQL to communicate with SQL databases. Have a look at those and post back if you have any further questions.

[Rupali]

Thanks for reply..

Does it mean I have to purchase those software...? Is there any other way...?

[AdnanZ]

The first one YES , but not the second one. I use LabSQL and it works perfect.

[Rupali]

Ok... The condition is same for LabVIEW 8.5 too....?

[Mathan]

It is irrespective of the version....

[Rupali]

Ok.. Thanks for the help...

[Rupali]

Hello Adnan Z... Can you show me how to use the VI's i downloaded from LabSQL zip file... Means if I have to store some text message in server or I have to read from server how to go for it...?

Message Edited by Rupali on 01-07-2009 01:31 AM

[AdnanZ]

Hi Rupali, I don't understand. You want to execute SQL statements to write something in the database or want to do something else? If it's SQL statements, have you already installed the database and the ODBC driver? When you download LabSQL, it has examples which shows how to communicate with the database.

[Rupali]

Ok.... Database means the records which are saved in excel sheet and those should be saved in server.... And one can be able to read or write in that.. this is what information I got for my project.. n I have to deal with SQL language..