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.