1. Set the SQL Engine Mode connection option to a value of 0 - Auto or 1 - Server. All fields on the SQL Engine tab become read only, and the Edit Server Settings button appears.
    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.
  2. Click Edit Server Setting to display the ODBC Cassandra SQL Engine Service Setup dialog box. Use this dialog box to define settings for Server Mode and to start and stop the SQL engine service.

    The SQL Engine Service Setup dialog box appears.


    The SQL Engine tab of the ODBC Cassandra Driver Setup dialog box

    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."

    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 19933 for 64-bit installations and 19934 for 32-bit installations. See "Server Port Number" for more information.

    Java Path: Specifies fully qualified path to the JVM executable that you want to use to run the SQL engine server. The path must not contain double quotation marks.

    Services: Shows the Cassandra 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 Cassandra service. A message window is displayed, confirming that the Cassandra service was started or stopped.

    Apply: Applies the changes.

    Note: After the initial configuration, in order for changes to these connection option values to take effect, you must restart the SQL engine server.
  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.