News CNCnetPDM About us Support  
       

CNCNETPDM FOR MYSQL AND MARIADB DATABASES | NEWS

TOP

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

Company | News | MTConnect Machine Monitoring Update

On Monday September 26 th 2022 we released an updated version of our device driver that adds OPC UA functionality and data output to... [read more]
Company | News | MTConnect Machine Monitoring Update

Company | News | Haas Machine Monitoring

On October 1 st 2022 we released a GUI program that enables reading and writing of data via Ethernet from/to machines equipped with Haas Standard or Next Generation Controls... [read more]
Company | News | Haas Machine Monitoring
Modified: 2018-02-12