skip to main content
Using the Driver : Configuring and Connecting to Data Sources : Configuring the Product Using the GUI : Web Service Tab
  

Try DataDirect Drivers Now
Web Service Tab
The Web Service Tab allows you to specify additional datasource settings. The fields are optional unless otherwise noted. On this tab, provide values for the options in the following table; then, click Apply.
Figure 5. Web Service tab
The Web Service tab of the ODBC Salesforce Driver Setup dialog box
Connection Options: Security
Description
Specifies the maximum number of Web service calls the driver can make when executing any single SQL statement or metadata query.
If set to 0, there is no limit.
If set to x, the driver uses this value to set the maximum number of Web service calls on a single connection that can be made when executing a SQL statement.
Default: 100
Specifies the behavior of the driver when the maximum Web service call limit specified by the Statement Call Limit option is exceeded.
If set to 1 - ErrorAlways, the driver returns an error if the maximum Web service call limit is exceed.
If set to 2 - ReturnResults, the driver returns any partial results it received prior to the call limit being exceeded. The driver generates a warning that not all of the results were fetched.
Default: 1 - ErrorAlways
Specifies the number of rows of data the driver attempts to fetch for each ODBC call.
If set to 0, the driver attempts to fetch up to a maximum of 2000 rows. This value typically provides the maximum throughput.
If set to x, the driver attempts to fetch up to a maximum of the specified number of rows. Setting the value lower than 2000 can reduce the response time for returning the initial data. Consider using a smaller WSFetch Size for interactive applications only.
Default: 0
The number of times the driver retries a timed-out Select request. Insert, Update, and Delete requests are never retried. The timeout period is specified by the WSTimeout (WST) connection option.
If set to 0, the driver does not retry timed-out requests after the initial unsuccessful attempt.
If set to x, the driver retries the timed-out request the specified number of times.
Default: 0
Specifies the time, in seconds, that the driver waits for a response to a Web service request.
If set to 0, the driver waits indefinitely for a response; there is no timeout.
If set to x, the driver uses the value as the default timeout for any statement created by the connection.
Default: 120
Specifies the maximum number of sessions the driver uses when multiple connections to Salesforce are established. This allows the driver to have multiple web service requests active when multiple ODBC connections are open, thereby improving throughput and performance.
Note: The value specified should not exceed the number of sessions permitted by your Salesforce account.
Default: 1
If you finished configuring your driver, proceed to Step 6 in "Configuring the Product Using the GUI". Optionally, you can further configure your driver by clicking on the following tabs. The following sections provide details on the fields specific to each configuration tab:
*General tab allows you to configure options that are required for creating a data source.
*SQL Engine tab allows you to configure the SQL Engine's behavior.
*Advanced tab allows you to configure advanced behavior.
*Pooling tab allows you to configure connection pooling behavior.
*Bulk tab allows you to specify settings for DataDirect Bulk Load.