News CNCnetPDM About us Support  
         

CNCNETPDM FOR MYSQL AND MARIADB DATABASES | NEWS

An updated version of CNCnet PDM (4.9.0.3) 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.

Database & table setup: https://www.inventcom.net/support/cncnetpdm-manual/mysql-mariadb-database-tables

CNCnetPDM database connectivity: https://www.inventcom.net/support/cncnetpdm-manual/database-connectivity#CONNECT_MYSQL

ERPINTERFACE.DLL

Version 4.9.0.3 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:

Setup CNCnetPDM.ini for MySQL and MariaDB: https://www.inventcom.net/support/cncnetpdm-manual/cncnetpdm-ini-file#CONNECT

Note: For users of CNCnetPDM 4.9.0.2 it is sufficient to just exchange erpinterface.dll with the most recent version

Release Notes: https://www.inventcom.net/support/cncnetpdm/release-notes
Download

 

Privacy notice

This website uses cookies. By continuing to use it you agree to our privacy policy. 

https://www.inventcom.net/company/news/cncnetpdm-for-mysql-and-mariadb-databases
Modified: 2018-02-12