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

Try DataDirect Drivers Now
Advanced Tab
The Advanced Tab allows you to specify additional data source settings. The fields are optional unless otherwise noted. On this tab, provide values for the options in the following table; then, click Apply.
Figure 3. Advanced tab
The Advanced Tab of the ODBC Salesforce Driver Setup dialog box
Connection Options: Advanced
Description
Determines whether the driver creates a new schema map when establishing the connection.
If set to 0 - No, the driver uses the current schema map specified by the Schema Map option. If one does not exist, the connection fails.
If set to 1 - ForceNew, the driver deletes the current schema map specified by the Schema Map option and creates a new one at the same location.
If set to 2 - NotExist, the driver uses the current schema map specified by the Schema Map option. If one does not exist, the driver creates one.
Default: 2 -NotExist
Specifies how the driver handles manual transactions.
If set to 1 - Ignore, the data source does not support transactions and the driver always operates in auto-commit mode. Calls to set the driver to manual commit mode and to commit transactions are ignored. Calls to rollback a transaction cause the driver to return an error indicating that no transaction is started. Metadata indicates that the driver supports transactions and the ReadUncommitted transaction isolation level.
If set to 0 - No Transactions, the data source and the driver do not support transactions. Metadata indicates that the driver does not support transactions.
Default: 0 - No Transactions
Determines whether the driver works with applications using multiple ODBC threads.
If set to enabled, the driver works with single-threaded and multi-threaded applications.
If set to disabled, the driver does not work with multi-threaded applications. If using the driver with single-threaded applications, this value avoids additional processing required for ODBC thread-safety standards.
Default: Enabled
Determines whether the driver automatically refreshes the information in a remote schema (rebuilds the schema map for the schema) the first time a user connects to the specified embedded database.
If set to 1 (Enabled), the driver automatically refreshes the schema map the first time a user connects to the specified database.
If set to 0 (Disabled), the driver does not automatically refresh the schema map the first time a user connects to the specified database.
Default: 0 (Disabled)
Specifies the number of rows that the driver processes before returning data to the application. Smaller fetch sizes can improve the initial response time of the query. Larger fetch sizes improve overall fetch times at the cost of additional memory.
Default: 100
If enabled, the connection has read-only access.
If disabled, the connection is opened for read/write access, and you can use all commands supported by the product.
Default: Enabled
The number of seconds the driver waits for a connection to be established before returning control to the application and generating a timeout error.
If set to -1, the connection request does not time out. The driver silently ignores the SQL_ATTR_LOGIN_TIMEOUT attribute.
If set to 0, the connection request does not time out, but the driver responds to the SQL_ATTR_LOGIN_TIMEOUT attribute.
If set to x, the connection request times out after the specified number of seconds unless the application overrides this setting with the SQL_ATTR_LOGIN_TIMEOUT attribute.
Default: 15
The number of seconds the driver waits for a connection to be established before returning control to the application and generating a timeout error.
If set to 0 - Ignore Errors, the driver substitutes 0x1A for each character that cannot be converted and does not return a warning or error.
If set to 1 - Return Error, the driver returns an error instead of substituting 0x1A for unconverted characters.
If set to 2 - Return Warning, the driver substitutes 0x1A for each character that cannot be converted and returns a warning.
Default: 0 - Ignore Errors
Specifies the filename of the configuration file used to initialize the driver logging mechanism. If the driver cannot locate the specified file when establishing the connection, the connection fails and the driver returns an error.
Default: None
One or multiple SQL commands to be executed by the driver after it has established the connection to the database and has performed all initialization for the connection. If the execution of a SQL command fails, the connection attempt also fails and the driver returns an error indicating which SQL command or commands failed.
Default: None
Determines how the mapping of the native data model to the relational data model is configured, customized, and updated.
Default: None
Extended Options: Type a semi-colon separated list of connection options and their values. Use this configuration option to set the value of undocumented connection options that are provided by Progress DataDirect Technical Support. You can include any valid connection option in the Extended Options string, for example:
CreateMap=0;UndocumentedOption1=value [;UndocumentedOption2=value;]
If the Extended Options string contains option values that are also set in the setup dialog or data source, the values of the options specified in the Extended Options string take precedence. However, connection options that are specified on a connection string override any option value specified in the Extended Options string.
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.
*Web Service tab allows you to configure the behavior of communications between the driver and web service.
*Pooling tab allows you to configure connection pooling behavior.
*Bulk tab allows you to specify settings for DataDirect Bulk Load.