1. Set the SQL Engine Mode connection property to a value of 1 - Server. All fields on the SQL Engine tab become readonly, and the Edit Server Settings button appears.
2. Click Edit Server Setting to display the ODBC Oracle Service Cloud SQL Engine Service Setup dialog box. Use this dialog box to define settings for Server Mode and to start and stop the Progress DataDirect Oracle Service Cloud SQL Engine service.
The SQL Engine Service Setup dialog box appears.
JVM Arguments: A string that contains the arguments that are passed to the JVM that the driver is starting. The location of the JVM must be specified on your PATH. See "JVM Arguments."
JVM Class Path: Specifies the CLASSPATH for the JVM used by the driver. See "JVM Classpath."
Proxy Host: Specifies the Hostname and possibly the Domain of the Proxy Server. The value specified can be a host name, a fully qualified domain name, or an IPv4 or IPv6 address.
Proxy Port: Specifies the port number where the Proxy Server is listening for HTTP and/or HTTPS requests.
Proxy User: Specifies the user name needed to connect to the Proxy Server.
Proxy Password:Specifies the password needed to connect to the Proxy Server.
Server Port Number: Specifies a valid port on which the SQL engine listens for requests from the driver. By default, the server listens on port 19929. See "Server Port Number" for more information.
Java Path: Specifies fully qualified path to the J2SE 5 or higher JVM executable that you want to use to run the SQL Engine Server. The path must not contain double quotation marks.
Server DB Directory: Specifies the path of the working directory for the SQL engine service to use to store the newly created database files or locate the existing database files. If the Database connection option contains a file name prefix, the user’s local database is created at the path specified by Server DB Directory. However, if the Database connection option contains a fully qualified path, the user’s local database is created using that path; the path specified by Server DB Directory is ignored.
Services: Shows the Oracle Service Cloud ODBC SQL engine service that runs as a separate process instead of being loaded within the process of an ODBC application.
Start (Stop): Starts or stops the Oracle Service Cloud service. A message window is displayed, confirming that the Oracle Service Cloud service was started or stopped.
Apply: Applies the changes.
3. When you complete your changes, click Apply.
4. Click OK to save the changes and return to the SQL Engine tab or click Cancel.
