PDA

View Full Version : RSView32 and MySQL


plc_va
June 10th, 2009, 07:35 PM
I want to data log to a MySQL database. MySQL is up and running along with RSView32. Does anyone have the RSView32 VB script/code that will connect to the MySQL server and write the data to it.

surferb
June 11th, 2009, 08:38 AM
Save yourself the hassle and use FactorySQL (http://www.inductiveautomation.com/products/factorysql/). Scripting within an HMI isn't a good (or easy) way to do data logging. Rockwell would recommend RSSQL/FactoryTalk Historian (running on MS SQL Server, of course).

I want to data log to a MySQL database. MySQL is up and running along with RSView32. Does anyone have the RSView32 VB script/code that will connect to the MySQL server and write the data to it.

plc_va
June 11th, 2009, 02:16 PM
What program do you guys use to view/import the datalog files (.mdf)?

plc noob
June 11th, 2009, 03:29 PM
Here is a very easy solution http://www.oldi.com/xcoupler_home.htm

If your processor is not clogix but plc5 or slc the use this http://www.oldi.com/catm_overview.htm as a gateway.

ghettofreeryder
June 11th, 2009, 05:44 PM
If you are using trendx, you just need to set up an odbc connection to the mysql server, and configure trendx to use that connection. No scripting is involved.

However, FactorySQL is a far better solution, and you can have it up and running in a matter of minutes. There support team is also top notch. Because RSView32 is also an OPC server, you can pull HMI tags or PLC tags and dump them into the database

surferb
June 11th, 2009, 07:14 PM
RSView32 doesn't need RSLinx anymore...?