Can the CompactRIO board log to an SQL database?

[sean m]

Hi All,

I have to run a long running test and it's very important we capture all the data over the period.  My "front end" is going to be a CompactRIO board doing all the measurements.  I have a server available with MySQL.  Can Labview write data from the CompactRIO direct to the database server?

Thanks for any help,

Sean

[mishkin]

Hey Sean,

The Labview Database VIs are ActiveX based, and therefore cannot be called directly from an RT system (ActiveX is Windows specific). However, if you are able to stream your data to a host PC first and write to MySQL database from there, you should not have a problem. 

Also, keep in mind that our DSC module comes with the Citadel databse, which provides powerful datalogging capabilities. 

If it is imperative that you do not go through a host PC first, the only solution I see is to write your own library of database access VIs (could be very complex). 

I hope that answers your question. Let me know if you need anything else. 

[preston_johnson]

Here is a link to RT sql code for vxworks

http://zone.ni.com/devzone/cda/epd/p/id/6287