Archestra MySQL

Hi,

How do I connect to the MySQL database from the ArchestrA? Please an example or a source where I could find it. Thank you for your help

ArchestrAnaut

http://www.avidsolutionsinc.com/blog/archestranaut/2011/02/interfacing-to-a-sql-database/

I wrote a simple VB.Net program that listens from serial port any msg from PLC. That program can coexist and run concurrently at the MySQL server. So, every time the PLC sends an INSERT blah, blah, the service translates and inserts directly into the schema.table

RheinhardtP said:

http://www.avidsolutionsinc.com/blog/archestranaut/2011/02/interfacing-to-a-sql-database/

Click to expand...

Just remember, the query is a String that most of the times, can be assembled in the PLC or, send a limited string with minimum info and then process in powerful VB.Net solution to create the proper query...