SQL capable RT system

[Morgue]

Are there means of communicating with an SQL Server from a real-time system like the cFP or cRIO?

I don't wish to stream huge amount of data to the server but simply to make queries to it in intervals of

several seconds. From what I read, the SQL Toolkit will not run under RT. I am looking for a solution

that does not require an extra PC between the RT system and the SQL server.

My RT target will be part of an industrial control system that should make desicions based on status

read back from the SQL.

/Stefan

Message Edited by Morgue on 03-12-2007 01:56 AM

[rolfk]

---

@Morgue wrote:

Are there means of communicating with an SQL Server from a real-time system like the cFP or cRIO?

I don't wish to stream huge amount of data to the server but simply to make queries to it in intervals of

several seconds. From what I read, the SQL Toolkit will not run under RT. I am looking for a solution

that does not require an extra PC between the RT system and the SQL server.

My RT target will be part of an industrial control system that should make desicions based on status

read back from the SQL.

/Stefan

Message Edited by Morgue on 03-12-2007 01:56 AM

---

This one is a tricky one but I think the most successful approach albeit not the most simple one is to use a database that has a documented network protocol interface.
MySQL as far as I know has that and I even think there have been people trying to write an MySQL LabVIEW library that talks directly to the MySQL server through TCP/IP. As long as you do not want to do to complicated things with the database I think this should be doable with a library of a dozen or so VIs.

Rolf Kalbermatter