In server mode, you must start the SQL engine server before using the driver. Before starting the SQL engine server, choose a directory to store the local database files. Make sure that you have the correct permissions to write to this directory.

By default, the JVM Classpath is set to the rightnow.jar file in the installation directory.

To start the SQL engine server:

  1. Start the ODBC Administrator by selecting its icon from the Progress DataDirect program group.
  2. Select a tab:
    • User DSN: If you are configuring an existing user data source, select the data source name and click Configure to display the driver Setup dialog box.

    If you are configuring a new user data source, click Add to display a list of installed drivers. Select the driver and click Finish to display the driver Setup dialog box.

    • System DSN: If you are configuring an existing system data source, select the data source name and click Configure to display the driver Setup dialog box.

    If you are configuring a new system data source, click Add to display a list of installed drivers. Select the driver and click Finish to display the driver Setup dialog box.

    • File DSN: If you are configuring an existing file data source, select the data source file and click Configure to display the driver Setup dialog box.

    If you are configuring a new file data source, click Add to display a list of installed drivers; then, select a driver. Click Advanced if you want to specify attributes; otherwise, click Next to proceed. Specify a name for the data source and click Next. Verify the data source information; then, click Finish to display the driver Setup dialog box.

  3. On the ODBC Oracle Service Cloud Driver Setup dialog box, select the SQL Engine tab; then, select 1- Server from the SQL Engine Mode drop-down list.
  4. Click Edit Server Settings.
  5. When you complete your changes, click Apply.
  6. Verify that Progress DataDirect Oracle Service Cloud SQL Engine is selected in the Services drop-down list, and then, click Start to start the service. A message window appears to confirm that the service is running. Click OK.
  7. Click OK to close the ODBC Oracle Service Cloud SQL Engine Service Setup dialog box.
    Note: If you made changes after starting the service, a message window is displayed:

    Exit without restarting message window for the SQL Engine Service dialog

    If you want the service to run with the new settings, click No. Then, click Stop to stop the service, and then click Start to restart the service. Then, click OK to close the ODBC Oracle Service Cloud SQL Engine Service Setup dialog box.