When I open the Viewer or WebViewer and click on a button that executes a script to query an Oracle database, a connection error to the database is generated. Why does it happen?
Solution:
It happens when you create a connection to the database via scripts. This will require a client to make the connection between Oracle Client and Server. It is recommended that you perform this connection with E3, so the Oracle Client will be installed in E3 Server, which in turn will pass the data to the Viewer.
To do so, you must first install the Oracle client in the computer where the domain is running. Then, create a DataBase object in the Server and a query for the table, and write a script to access this database via RecordSet in the query. Thus, you will not need an Oracle Client installed in the machine where the script will run.