Some applications may experience problems loading the JVM required for the SQL engine because the process exceeds the available heap space. If your application experiences problems loading the JVM, you can configure the Salesforce driver to operate in server mode.By default, the Salesforce driver operates in direct mode, with the SQL engine and JVM running in a single 32-bit process within the same JVM. In server mode, the driver's SQL engine runs in a separate 32-bit process with its own JVM instead of trying to load the SQL engine and JVM in the same process used by the driver.
If SQLEngineMode is set to set to 1 (Server) for the datasource in odbc.ini or GUI tab of the ODBC Adminsitrator the SQL engine runs in server mode.In Server Mode SQL engine operates in a separate process from the driver within its own JVM. User must start the SQL Engine service before using the driver . Multiple drivers on different clients can use the same service.
Starting SQL Engine in Server Mode on Linux/Unix:
a] SQLEngineMode=1 must be set in the odbc.ini
b] Go to the java/jre location used by the driver and execute the command like below :
Salesforce ODBC Driver:
java -Xmx1024m -cp [ODBC_INSTALL_DIR]/java/lib/sforce.jar com.ddtek.sforcecloud.sql.Server -port 19928 &
Oracle Service Cloud
java -Xmx1024m -cp [ODBC_INSTALL_DIR]/java/lib/rightnow.jar com.ddtek.rightnowcloud.sql.Server -port 19928 &
To shutdown the server enter "Control-C"
Starting SQL Engine in Server Mode on Windows
1] Using the GUI Tab
To define the settings for server mode, click Edit Server Settings from the SQL Engine tab. The SQL Engine Service Setup dialog box appears.Use the SQL Engine Service Setup dialog box to configure server mode and to start or stop the service.
Note: You must be an administrator to modify the server mode settings. Otherwise, the Edit Server Settings button does not appear on the SQL Engine tab.
a] On the ODBC Salesforce Driver Setup dialog box, select the SQL Engine tab; then, select 1- Server from the SQL Engine Mode drop-down list.When you complete your changes, click Apply.
b] Verify that Progress DataDirect Salesforce 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.
c] Click OK to close the ODBC Salesforce SQL Engine Service Setup dialog box.
If you made changes after starting the service, a message window is displayed:
d] 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 Salesforce SQL Engine Service Setup dialog box.
2] Using Windows command prompt
a] Ensure SQLEngineMode=1 for the Salesforce datasource in ODBC Administrator
b] Open the command prompt as Administrator and go to the java/jre location used by the driver and execute the command like below:
"C:\Program Files(x86)\Progress\DataDirect\Connect_for_ODBC_71\jre\bin\java.exe -Xmx1024m -cp "C:\Program Files (x86)\Progress\DataDirect\Connect_for_ODBC_71\java\lib\sforce.jar" com.ddtek.sforcecloud.sql.Server -port 19928