ODBC database processor does not react correctly to SQL Server restart

ODBC database processor does not react correctly to SQL Server restart

Summary

Whenever an operation fails (like due to the error shown in the description), the cached objects are cleared. This forces a recreation of the prepared statement after statement execution fails and connectivity comes back online.

Description

Whenever an operation fails (like due to the error shown in the description), the cached objects are cleared. This forces a recreation of the prepared statement after statement execution fails and connectivity comes back online.

Information

Restart Service Engine



Issue Number: 250818
Fixed on Date: 12.4.2022
Versions: 10 0 BUILD 98635

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

    • Database cannot be opened! (SQL Authentication Error)

      When opening zenon, one may encounter the following message in the output window: Taking a glimpse at the logs reveals that there are authentication errors regarding zenon's default database user "zenOnSrv". Therefore, no projects can be opened. ...

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

    • Checklist: Distributed Engineering – Engineering Studio cannot connect to the Project Database-Server / Elements cannot be checked-in/out

      Time estimate: 45 minutes Please go through all the items in the following checklist. If necessary, confirm any information you cannot verify with the IT department before contacting your local COPA-DATA representative.  Checklist usage: #. [Quick ...

    • Database error 0x80040154: Class not registered.

      Issue: Archive can not be evacuated Log shows error: Database error 0x80040154: Class not registered. Problem: Engineering Studio configured a SQL provider to be used, which does not exist on the Service Engine PC. Solution: Install the configured ...