mySQL

[terobaje]

How do I connect LabVIEW to MySQL server ?

[mikeporter]

Through ADO. You can use the drivers you'll find here. You'll also need the myOleDB drivers from here.

Mike...

[terobaje]

Thank you for quick respose. Is there any more software to install ? We have to put real-time data from LabVIEW cRIO to MySQL database server so do these two software are sufficient to get the work done ? 

What does SmartSQL VIEW work for ?

[mikeporter]

The response I gave you was how to access a mySQL server from the Windows version of LV. I don't think you can put data directly into a database directly from a cRIO. NI recently announced a new product called Raima (not the Bollywood actress!) that provides some level of database support, but I don't know if this will help with mySQL or if it supports all cRIO devices or just the new Linux-based one.

If that doesn't work you will have to pass the data from the cRIO to a small headless windows executable that inserts it into the database.

Mike...

[mikeporter]

I did a quick look right now at the SmartSQLView product and it looks like it would work, but for $700?!?! Yikes...

Mike...

[Ranjeet_Singh]

Use UDL file...Here is an example

[smithd]

Sounds like the core issue is that you want to log data from cRIO to a host machine. Depending on the type of data you might look at either DSC (which has built-in db logging capabilities, although I don't know if they can target mysql), smartsqlview mysql, or this library: 

https://forums.ni.com/t5/Example-Code/Native-LabVIEW-TCP-IP-Connector-for-mySQL-Database/ta-p/349660...

Note: it is very primitive compared to the mysqlview toolkit and you need to know sql. Its not hard, but its not easy. The saphir toolkit is supported and as you can see from the reviews, really quite good 🙂

Another mechanism would be to use raw TCP/streams/something else to transfer the data back to a host machine which does the actual db logging. I think this is more along the lines of a standard architecture, where you have a cRIO/device out on the network, then you have a device-specific driver to pass the raw data to the host (ie an OPC server and its drivers) and then you have a historian to log the data (client of the OPC server).

Unless I am terribly mistaken, Raima is a fully fledged database solution which now has a cRIO-compatible driver, rather than an API like the db connectivity toolkit.

[WWarren]

Regarding the Raima Database API for LabVIEW, it will manage databases through LabVIEW on either cRIO or Windows. But if your target system is MySQL, it does not facilitate that yet.

The next version of the Raima API will support replication from cRIO databases to 3rd party databases such as MySQL or Oracle. But that is a few months away.