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

Company | News | Siemens Machine Monitoring Important Update

On Tuesday April 26 2022 we released important updates of our solutions for data acquisition from machines with Siemens Sinumerik controllers that run OPC Classic which is based... [read more]
Company | News | Siemens Machine Monitoring Important Update

Company | News | License & Service Fee Adjustment

This is a notice that there was an adjustment in our product & service pricing that took effect on June 1 st 2022 . Details on the changes can be found here:... [read more]
Company | News | License & Service Fee Adjustment
Modified: 2018-02-12