Fail to update dynamically generated DataWindow

Dynamically generated DataWindow cannot be updated.

Cause: Uses the former version of Microsoft SQL Server 2005 SP1 with MSFT JDBC Driver.

Solution:

Step 1: Replace the former version of Microsoft SQL Server 2005 SP1 with MSFT JDBC Driver with the latest one, which can be downloaded from the Microsoft Website.

Step 2: Execute the stored procedure SQL statement install_appeon_syntaxfromsql_MSSQL.sql (located in Appeon installation path %AppeonHome%/sql/dynamicsql) in the SQL Server 2005 database server.

Step 3: Restart the application server.