SQL Engine Tab

The SQL Engine can be run in one of two modes: direct mode or server mode. When set to direct mode, both the driver and its SQL engine run in the ODBC application's address space. Some applications may experience problems loading the JVM because the process exceeds the available heap space. To avoid this issue, you can configure the driver to operate in server mode. Server mode allows the driver to connect to an SQL engine JVM running as a separate service.

Table 6. SQL Engine Tab Connection Options
Connection Options: SQL Engine	Default
SQL Engine Mode	Specifies whether the driver’s SQL engine runs in the same 32-bit process as the driver (direct mode) or runs in a process that is separate from the driver (server mode). If set to 0 - Auto, the SQL engine attempts to run in server mode first; however, if server mode is unavailable, it runs in direct mode. If set to 1 - Server, the SQL engine runs in server mode. The SQL engine operates in a separate process from the driver within its own JVM. If the SQL engine is unavailable, the connection will fail. If set to 2 - Direct, the SQL engine runs in direct mode. The driver and its SQL engine run in a single process within the same JVM. Important: When the SQL engine is configured to run in server mode (0-Auto \| 1-Server), you must start the SQL Engine service before using the driver (see "Starting the SQL Engine Server" for more information). Multiple drivers on different clients can use the same service. Important: Changes you make to the server mode configuration affect all DSNs sharing the service. Default: 0 - Auto
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 the driver library path. Values that include special characters or spaces must be enclosed in curly braces { } when used in a connection string. Default: For the 32-bit driver when the SQL Engine Mode is set to 2 - Direct: -Xmx256m For all other configurations: -Xmx1024m
JVM Classpath	Specifies the CLASSPATH for the Java Virtual Machine (JVM) used by the driver. The CLASSPATH is the search string the JVM uses to locate the Java jar files the driver needs. Separate multiple jar files by a semi-colon on Windows platforms and by a colon on all other platforms. CLASSPATH values with multiple jar files must be enclosed in curly braces { } when used in a connection string. Note: If no value is specified, the driver automatically detects the CLASSPATHs for all ODBC drivers installed on your machine. Default: Empty String

Table 7. Server Mode Configuration Options
Configuration Options: SQL Engine Service	Description
Server Port Number	Specifies a valid port on which the SQL engine listens for requests from the driver. Default: For the 32-bit driver: 19942 For the 64-bit driver: 19941
Java Path	Specifies fully qualified path to the Java SE 8 or higher JVM executable that you want to use to run the SQL Engine Server. The path must not contain double quotation marks. Default: The fully qualified path to the Java SE 8 or higher JVM executable (java.exe)
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 Schema Map 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.