Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\salesforce.27.16.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Configuring the SQL Engine Server</title> <link rel="StyleSheet" href="css/salesforce.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="salesforce.27.01.html#1579796">21 The Salesforce Driver</a> : Configuring the SQL Engine Server</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="1579796">Configuring the SQL Engine Server</a></div> <div class="Body"><a name="1606722">Some applications may experience problems loading the JVM required for the SQL engine </a>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. </div> <div class="Body"><a name="1629520">By default, the Salesforce driver operates in direct mode, with the SQL engine and JVM </a>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.</div> <div class="Body"><a name="1617823">NOTE: You must be an administrator to start or stop the service, or to configure any settings </a>for the service.</div> <div class="head_2"><a name="1579806">Configuring Server Mode</a></div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="1579807">Set the SQL Engine Mode connection property to a value of </a><span class="Syntax">1 - Server</span>. All fields on the SQL Engine tab become readonly, and the <span class="Action_bold">Edit Server Settings</span> button appears.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="1579808">Click </a><span class="Action_bold">Edit Server Setting</span> 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.</div> </td> </tr> </table> </div> <div class="Body_Indent"><a name="1626362">The SQL Engine Service Setup dialog box appears.</a></div> <div class="picture"><a name="1626371"><img class="procedure" src="images/sqlengineservermode.gif" width="390" height="534" style="display: block; float: none; left: 0.0; top: 0.0;" alt="The SQL Engine Service dialog of the ODBC Salesforce Driver Setup dialog box" /></a></div> <div class="Body_Indent"><span class="Action_bold"><a name="1626378">JVM Arguments</a></span>: 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 <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1226399', '');">JVM Arguments</a></span>.</div> <div class="Body_Indent"><span class="Action_bold"><a name="1626382">JVM Class Path</a></span>: Specifies the CLASSPATH for the JVM used by the driver. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1226669', '');">JVM Classpath</a></span>.</div> <div class="Body_Indent"><span class="Action_bold"><a name="1626386">Proxy Host</a></span>: Specifies the Hostname and possibly the Domain of the Proxy Server. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1227698', '');">Proxy Host</a></span>.</div> <div class="Body_Indent"><span class="Action_bold"><a name="1626390">Proxy Port</a></span>: Specifies the port needed to connect to the Proxy Server. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1243243', '');">Proxy Port</a></span>.</div> <div class="Body_Indent"><span class="Action_bold"><a name="1626394">Proxy User</a></span>: Specifies the user name needed to connect to the Proxy Server. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1227867', '');">Proxy User</a></span>.</div> <div class="Body_Indent"><span class="Action_bold"><a name="1626398">Proxy Password</a></span>: Specifies the password needed to connect to the Proxy Server. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1227802', '');">Proxy Password</a></span>.</div> <div class="Body_Indent"><span class="Action_bold"><a name="1640175">Server Port Number</a></span>: Specifies a valid port on which the SQL engine listens for requests from the driver. By default, the server listens on port 19928. See <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1597132', '');">Server Port Number</a></span> for more information.</div> <div class="Body_Indent"><span class="Action_bold"><a name="1640179">Java Path</a></span>: 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.</div> <div class="Body_Indent"><span class="Action_bold"><a name="1640180">Server DB Directory</a></span>: 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 <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.04.html#1061996', '');">Database</a></span> 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. </div> <div class="Body_Indent"><span class="Action_bold"><a name="1626402">Services</a></span>: Shows the Salesforce ODBC SQL engine service that runs as a separate process instead of being loaded within the process of an ODBC application. </div> <div class="Body_Indent"><span class="Action_bold"><a name="1633592">Start</a></span> (<span class="Action_bold">Stop</span>): Starts or stops the Salesforce service. A message window is displayed, confirming that the Salesforce service was started or stopped.</div> <div class="Body_Indent"><span class="Action_bold"><a name="1633647">Apply</a></span>: Applies the changes.</div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="1626403">When you complete your changes, click </a><span class="Action_bold">Apply</span>. </div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">4 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="1626404">Click </a><span class="Action_bold">OK</span> to save the changes and return to the SQL Engine tab or click <span class="Action_bold">Cancel</span>.</div> </td> </tr> </table> </div> <div class="head_2"><a name="1579822">Starting the SQL Engine Server</a></div> <div class="Body"><a name="1579823">In server mode, you must start the SQL engine server before using the driver. Before </a>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.</div> <div class="Body"><a name="1579824">By default, the JVM Classpath is set to the sforce.jar file in the installation directory.</a></div> <div class="hanging_label_head"><a name="1579825">To start the SQL engine server:</a></div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="1626563">Start the ODBC Administrator by selecting its icon from the DataDirect Connect </a>program group. </div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="1626673">Select a tab:</a></div> </td> </tr> </table> </div> <div class="list_bulleted_proc_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_proc_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_proc_inner"><span class="Action_bold"><a name="1626674">User DSN</a></span>: If you are configuring an existing user data source, select the data source name and click <span class="Action_bold">Configure</span> to display the driver Setup dialog box.</div> </td> </tr> </table> </div> <div class="Body_Indent_Sub"><a name="1626675">If you are configuring a new user data source, click </a><span class="Action_bold">Add</span> to display a list of installed drivers. Select the driver and click <span class="Action_bold">Finish</span> to display the driver Setup dialog box.</div> <div class="list_bulleted_proc_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_proc_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_proc_inner"><span class="Action_bold"><a name="1626676">System DSN</a></span>: If you are configuring an existing system data source, select the data source name and click <span class="Action_bold">Configure</span> to display the driver Setup dialog box.</div> </td> </tr> </table> </div> <div class="Body_Indent_Sub"><a name="1626685">If you are configuring a new system data source, click </a><span class="Action_bold">Add</span> to display a list of installed drivers. Select the driver and click <span class="Action_bold">Finish</span> to display the driver Setup dialog box.</div> <div class="list_bulleted_proc_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_proc_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_proc_inner"><span class="Action_bold"><a name="1626686">File DSN</a></span>: If you are configuring an existing file data source, select the data source file and click <span class="Action_bold">Configure</span> to display the driver Setup dialog box.</div> </td> </tr> </table> </div> <div class="Body_Indent_Sub"><a name="1626687">If you are configuring a new file data source, click </a><span class="Action_bold">Add</span> to display a list of installed drivers; then, select a driver. Click <span class="Action_bold">Advanced </span>if you want to specify attributes; otherwise, click <span class="Action_bold">Next</span> to proceed. Specify a name for the data source and click <span class="Action_bold">Next</span>. Verify the data source information; then, click <span class="Action_bold">Finish</span> to display the driver Setup dialog box.</div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="1614091">On the ODBC Salesforce Driver Setup dialog box, select the </a><span class="Action_bold">SQL Engine</span> tab; then, select <span class="Action_bold">1- Server</span> from the SQL Engine Mode drop-down list.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">4 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="1626609">Click </a><span class="Action_bold">Edit Server Settings</span>.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">5 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="1633723">When you complete your changes, click </a><span class="Action_bold">Apply</span>. </div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">6 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="1614102">Verify that Progress DataDirect Salesforce SQL Engine is selected in the Services </a>drop-down list, and then, click <span class="Action_bold">Start</span> to start the service. A message window appears to confirm that the service is running. Click <span class="Action_bold">OK</span>.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">7 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="1579829">Click </a><span class="Action_bold">OK</span> to close the ODBC Salesforce SQL Engine Service Setup dialog box. </div> </td> </tr> </table> </div> <div class="Body_Indent"><a name="1633867">NOTE: If you made changes after starting the service, a message window is displayed:</a></div> <div class="picture"><a name="1633871"><img class="procedure" src="images/sqlenginerunning.gif" width="475" height="154" style="display: block; float: none; left: 0.0; top: 0.0;" alt="Exit without restarting message window for the SQL Engine Service dialog" /></a></div> <div class="Body_Indent"><a name="1633872">If you want the service to run with the new settings, click </a><span class="Action_bold">No</span>. Then, click <span class="Action_bold">Stop</span> to stop the service, and then click <span class="Action_bold">Start</span> to restart the service. Then, click <span class="Action_bold">OK</span> to close the ODBC Salesforce SQL Engine Service Setup dialog box.</div> <div class="head_2"><a name="1579831">Stopping the SQL Engine Server</a></div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="1579832">To stop the SQL engine server, open the ODBC Salesforce Driver Setup dialog box and </a>select the SQL Engine tab. </div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="1626880">Select </a><span class="Action_bold">1- Server</span> from the SQL Engine Mode drop-down list. Then, click <span class="Action_bold">Edit Server </span><span class="Action_bold">Settings</span>.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="1626881">Click </a><span class="Action_bold">Stop</span> to stop the service. A message window appears to confirm that the service is stopped. Click <span class="Action_bold">OK</span>.</div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">4 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="1626882">Click </a><span class="Action_bold">OK</span> to close the ODBC Salesforce SQL Engine Service Setup dialog box. </div> </td> </tr> </table> </div> <div class="head_2"><a name="1579833">Configuring Java Logging for the SQL Engine Server</a></div> <div class="Body"><a name="1579834">Java logging can be configured by placing a logging configuration file named </a>ddlogging.properties in the Server DB directory (see <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('ODBC', 'salesforce.27.16.html#1579806', '');">â??Configuring Server Modeâ??</a></span> for information on configuring Server DB Directory). The simple way to create one of these is to make a copy of the ddlogging.properties file, which is located in your driver installation directory, in the <span class="EquationVariables">install_dir</span>/Sample/Example subdirectory. For more information on logging in Salesforce, refer to <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('troubleshooting', 'diagnostic.3.5.html#111095', '');">â??Logging (Salesforce Driver)â??</a></span> in <span class="Cross_ref_"><a href="javascript:WWHClickedPopup('troubleshooting', 'diagnostic.3.1.html#108583', '');">Chapter 1</a></span> of the in the <span class="Emphasis">DataDirect Connect Series for ODBC Troubleshooting Guide</span>.</div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de