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

    • 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 / ...

    • Checklist: OPCDA Server

      Time estimate: 20 minutes Please go through all the points in the following checklist. If necessary, confirm with IT Department any information you cannot verify before contacting your local COPA-DATA Representative. Do NOT use DCOM in combination ...

    • 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 ...

    • 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 ...

    • Acknowledgement of alarms limited to equipment groups does not work if the user data comes from an external identity provider (AD, Identity Service)

      Summary The acknowledgement of alarms that are restricted to system groups does not work if the user data originates from an external identity provider such as Active Directory or Identity Service. This error has been fixed. Description In AML, the ...