zenon Logic should support access to MySQL and SQLite

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