skip to main content
Part 4: The Connect XE Drivers : The Salesforce Driver : Configuring the SQL Engine Server : Configuring Server Mode
  
Configuring Server Mode
1. Set the SQL Engine Mode connection property to a value of 1 - Server. All fields on the SQL Engine tab become readonly, and the Edit Server Settings button appears.
2. Click Edit Server Setting to display the ODBC Salesforce SQL Engine Service Setup dialog box. Use this dialog box to define settings for Server Mode and to start and stop the Progress DataDirect Salesforce SQL Engine service.
The SQL Engine Service Setup dialog box appears.
The SQL Engine tab of the ODBC Salesforce 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.
Proxy Host: Specifies the Hostname and possibly the Domain of the Proxy Server. See Proxy Host.
Proxy Port: Specifies the port needed to connect to the Proxy Server. See Proxy Port.
Proxy User: Specifies the user name needed to connect to the Proxy Server. See ProxyUser.
Proxy Password: Specifies the password needed to connect to the Proxy Server. See Proxy Password.
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 19928. See Server Port Number for more information.
Java Path: Specifies fully qualified path to the J2SE 5 or higher JVM executable that you want to use to run the SQL Engine Server. The path must not contain double quotation marks.
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 Database connection option contains a file name prefix, the user’s local database is created at the path specified by Server DB Directory. However, if the Database 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.
Services: Shows the Salesforce 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 Salesforce service. A message window is displayed, confirming that the Salesforce service was started or stopped.
Apply: Applies the changes.
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.