An updated version of CNCnet PDM (18.104.22.168) with proper support for MySQL and MariaDB databases (Version >= 5.5) is available for download. As Data Types in MySQL and MariaDB differ from Oracle we created an own page with database and table setup instructions. We also added setup instructions for CNCnetPDM database connectivity to these products.
Version 22.214.171.124 of erpinterface.dll now supports all product-specific 'select', 'insert' and 'update' commands for MySQL and MariaDB databases. Mixing of machine data with work-orders, items and parts from solutions for operational data acquisition as well as detection of an active shift for specific devices is also included.
Appart from using the correct UDL file in section [Connect] of CNCnetPDM.ini 'DB_TYPE = 3' has to be used for MySQL and MariaDB databases: