Upgrading ECDA for Oracle or ECDA for ODBC

Upgrade ECDA for Oracle or ECDA for ODBC server from 15.0 and later.

Prerequisites

Back up the current ECDA directory tree from the install directory, including all sub-directories as downgrades are not supported.
Note: Any ECDA or DC for z/OS product that is version 15.0 or later can be upgraded with a newer version of the product.
Take the services inventory and configuration properties currently running on the server using DCManager or copy the configuration files to a safe location and refer to those later.

Task

Stop ECDA for Oracle or ECDA for ODBC server.
Use the relevant version of the Enterprise Connect Data Access Installation Guide (this document) to install the newer version of ECDA in to the same based directory. For example, %SYBASE% directory.
For the ECDA for Oracle server, follow any instructions in the installation guide about downloading instant client libraries. This is necessary as the requirements for these libraries may have changed from the server you are upgrading.
Restart the ECDA server.
Run the DCManager GUI tool and connect to the new server instance to validate that the configuration properties and services are running as expected and match it to the inventory you created in the prerequisite section.
Use isql to connect to the target databases through each of the services and issue a simple select command to validate the connection.