Evacuation via OLE DB Provider for SQL Server results in crashes on latest zenon builds

Evacuation via OLE DB Provider for SQL Server results in crashes on latest zenon builds

Summary

When evacuating archives, zenon crashes in some cases.

Description

When evacuating archives via the OLE DB Provider for SQL Server, crashes of zenon occur.

Cause:

This is caused by using an outdated OLE DB Provider that is not suitable for multi-line insertion.

Solution:

Multi-line insertion is disabled for OLE DB Provider for SQL Server (SQLOLEDB).

To benefit from this fix:

  • Update your zenon Software Platform to the latest build of zenon 11 or higher.

Recommendation:

  • Avoid the OLE DB Provider for SQL Server (SQLOLEDB) as well as SQL Server Native Client (SNAC), which are no longer maintained by Microsoft.
  • Use the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) as recommended by Microsoft.

 



Item ID: 259374
Version: 11.00 Build: 115310

    • Related Articles

    • zenon Changesets CSV

      Here, you can access a comprehensive list of changes across all maintained versions of the zenon Software Platform as Excel Worksheets. This includes both implemented bug-fixes and new features. Additionally, these lists are available in as Excel ...

    • zenon Changesets Excel

      Here, you can access a comprehensive list of changes across all maintained versions of the zenon Software Platform as Excel Worksheets. This includes both implemented bug-fixes and new features. Additionally, these lists are available in CSV format ...

    • FAQ: SQL Server 2019 End of Life and Product Update Recommendations

      This article contains link to external information not maintained by Ing. Punzenberger COPA-DATA Gmbh. Which SQL Server version is included in your installation? In the zenon versions 12, 11, and 10, the installation package included Microsoft SQL ...

    • FAQ: What SQL server interfaces are offered by zenon?

      The most common ones are: The zenon Historian The Extended Trend The zenon Report Generator The zenon Report Engine The zenon SQL export functions The zenon SQL Driver and The zenon Process Gateway SQL module All these modules depend on an ODBC / ...

    • FAQ: Archive configuration for best SQL evacuation performance

      The time required to evacuate data to a database increases linearly with the number of insert SQL statements. In earlier zenon versions, recorded values were evacuated to the target database sequentially using single-insert statements. From zenon 11 ...