help required in passing data to a database..!!

[NitzZ]

Hi all,

I am working with a VI which generates a table data as output and i want to pass this data to an online database, may be using SQL. But as I am not so good with SQL and other database management systems, can anyone please tell me how to do this. An example VI would be appreciated.

Thankful regards,

Nitz

[NitzZ]

Hi all,

It would have been very kind if someone cared to reply.

Regards,

Nitz

[Dennis_Knutson]

You will want the Database Connectivity Toolkit. It comes with examples.

[smercurio_fc]

An alternative is to use LabSQL, but this doesn't have the support that the NI toolkit has.

[NitzZ]

I tried the database connectivity toolkit.. but i am getting an error..

Can you please tell me where am I going wrong.

Regards,

Nitz

[Gak]

Here are few links you might want to have a look at

https://forums.ni.com/t5/Example-Code/Insert-Data-into-DataBase-from-an-Array-using-LabVIEW-Database...

Create tables and columns

Geeting column headers

Best of Luck

[NitzZ]

Hi Gaurav,

Thanks for your help.. I will go through these examples and try to make out something..

Regards,

Nitz

[NitzZ]

Hi ,

I tried doing this with the data connectivity tool kit.. But still I am getting some errors and not being able to get the results what I want. I have attached the vi and access file on which i am working. What i am trying to do is, when ever i press the enter button, i want the strings entered in the three string controls updated into the database table. But when I am doing this, the first value is getting entered and after that I am getting an error.

Please help me how to handle this data connectivity toolkit...

Thankful regards,

Nitz..