OPC to MySQL: Writing OPC to the MySQL database
Configuring how to write OPC data to a MySQL database is similar to configuring how to write data to MSSQL. Only the main differences are described in this manual.
1. Download and install the 32-bit version of MySQL ODBC Connector (the ODBC driver) for MySQL from mysql.org.
Fig. 1 Driver section
2. The structure of a table in the database will look like this:
2.1 In the case of writing a lot of OPC items
2.2 In case of writing several OPC items
If you specify any other data type than String for ITEM1 or ITEM2 in the OPC settings, you should create the columns of the corresponding types while creating a table.
3. Create an ODBC data source for your MySQL database.
4. During "Binding", you should take into account that the names of the table and its columns are case-sensitive in MySQL.
OPC and DCOM Configuration on Windows 2008 and Windows 7
OPC and DCOM Configuration on Windows Server 2012 and Windows 8