To insert a new Oracle Database, follow these procedures:
1.Right-click the project's name in Explorer and select the Insert - Database option. In Domain mode, right-click the Server objects - Databases item, select the Insert Database In option, and then the project's name. The object is then created and its script edition window is opened.
2.To configure it, go to the Configuration tab on the Properties Window.
Configuration for an Oracle Database
The available options on this tab are described on the next table.
Available options for Configuration tab
Option |
Description |
|---|---|
Database |
Selects a project's Database type. Possible values for this option are 0: stAccess, 1: stOracle, or 2: stSqlServer |
Connection |
Allows selecting a local connection, if available, or typing the name of a connection provided by a database administrator |
Use ADO Oracle drivers |
Allows using Oracle's ADO (ActiveX Data Objects) interfaces, so that an E3 Query object recognizes a TIMESTAMP data type, enabled in the Use TIMESTAMP type option. Then users can read records from Oracle databases with a precision of milliseconds. Please check the next note for more information about this option |
Use TIMESTAMP type |
Allows using Oracle's TIMESTAMP data type, with a precision of milliseconds and available since version 9.0. If this option is disabled, uses a DATE data type, with a precision of seconds. Please check the next note for more information about this option |
User |
Database user, connected via E3 |
Password |
Password of the user performing the logon |
Test Connection |
Tests connection with the Database |
•Removing the selection of the Use ADO Oracle drivers option automatically removes the selection of the Use TIMESTAMP type option. •Applications created in versions earlier than version 5.0, when executed in version 5.0 or later or when loading a Database object in E3 Studio, automatically select the Use ADO Oracle drivers option if the Use TIMESTAMP type option is selected. •In E3 Studio, users are asked if they want to save that change. •When executing this application, that change persists only during the execution, returning to the previous status until users save that change. |
3.In the Database field, select the 1 - stOracle option.
4.If the Oracle server is a local server, the Connection field may remain blank, because E3 automatically retrieves this information. Otherwise, the connection is created using an Oracle client installed in the machine.
5.If necessary, configure the User and Password options according to Oracle settings. Such items may remain blank and, in this case, an application assumes E3 default configurations.
6.Click OK to finish these settings.
When inserting a Database in an application, some options regarding Database Server types are enabled. A Database Server is responsible for managing and storing information about objects that use this service.