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 cassandra.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 for ODBC 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 Cassandra Driver Setup dialog box, select the SQL Engine tab; then, select 0 - Auto or 1- Server from the SQL Engine Mode drop-down list.
    Note: Server mode is enabled when the SQL Engine Mode connection option is set to 0 - Auto or 1- Server. When set 0 - Auto, the SQL engine attempts to run in server mode first, but will failover to direct mode if server mode is unavailable. When set to 1 - Server, the SQL engine mode runs exclusively in server mode.
  4. Click Edit Server Settings.
  5. When you complete your changes, click Apply.
  6. Verify that Progress DataDirect Cassandra 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 Cassandra 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 Cassandra SQL Engine Service Setup dialog box.