zenon Logic should support access to MySQL and SQLite
Summary
It should be possible to access MySQL and SQLite databases by usage of function blocks inside zenon Logic.
Description
It should be possible to access MySQL and SQLite databases by usage of function blocks inside zenon Logic.
Solution
New function Blocks are introduced to zenon Logic.
FB: MYSQLCONNECT
This block opens a connection to a remote or local MySql server. It also select the database that will be used.
FB: SQLITECONNECT
This block opens a SQLite database.
Information
Because of licensing reasons, to use the block MYSQLCONNECT it is necessary to download the connector library from MySQL.
https://dev.mysql.com/downloads/connector/c/6.0.html
Connector/C 6.0.2 is needed.
After installing the connector, you may need to copy the file libmysql.dll to the installation folder of zenon Logic.
Issue Number: 37671
Fixed on Date: 12.1.2017
Versions: 7.60 0 BUILD 36068