[DRIVER_SETTINGS]

Use the [DRIVER_SETTINGS] section of the assignment file to specify the database and component engine connectors used, and their parameter options. The options available depend on the connector in use.

Syntax

[DRIVER_SETTINGS]

ConnectorCode {=} UConnectorVersion

USYS$ConnectorCode_PARAMSOption1 {,Option2, ... ,OptionN}

For example: 

[DRIVER_SETTINGS]
SLE     U1.0
USYS$SLE_PARAMS create db = on, identifiers = quoted

Arguments

  • ConnectorCode—three-character code for a database or component engine connector; for example ORA for the Oracle database connector, or SOP for the SOAP component connector.
  • ConnectorCode—three-character code for the connector; for example TCP or TLS for a network connector, MSS for the Microsoft SQL Server database connector, or SOP for the SOAP component connector.
  • ConnectorVersion—version of the connector, for example U6.0. For supported connector versions, see the Platform Availability Matrix.
  • Option—connector-specific option.

Description

You can use the [DRIVER_SETTINGS] setting section to configure the network, database, and SOAP connectors:

  • For database connectors, you must declare the connector and version. For example:
    [DRIVER_SETTINGS]
 SLE     U1.0

    You can then us the USYS$XXX_PARAMS setting to configure the specified connector. For example:

    USYS$SLE_PARAMS create db = on, identifiers = quoted
  • For the TCP and TLS network connector s , you can just set the connector options. The connectors are available in the Uniface installation by default.

To configure access to a database connector, you must specify that logon path in the [PATHS] section of client assignment files.

For web services, settings in the [SERVICES_EXEC] section can override the SOAP connector options set in [DRIVER_SETTINGS].

Connector Settings

Each assignment can be no longer than one line in the assignment file. For all options, the default action is used by the connector unless specifically overridden by using the appropriate parameter.

All options have the form Directive = Value. Instead of the equal sign (=), a colon can be used. Multiple settings can be concatenated by comma-separating options. For example: 

[DRIVER_SETTINGS]
USYS$SLE_PARAMS = default locking:cautious, stepsize = off

Some connector options are mutually exclusive or will not work together. In this case, the last option specified takes precedence. For example, if you were to specify USYS$MQL_PARAMS blobs:on, segmented fields: off (these switches do the same thing), then support for blobs is turned off.

Network Connector Settings
Connector Protocol Connector Parameters More Information
TCP TCP/IP USYS$TCP_PARAMS TCP Connector Options
TLS TLS/SSL USYS$TLS_PARAMS

TLS Connector Options

Note:  There is also a COM connector, but it is not configured in the [DRIVER_SETTINGS] section. Instead, you can append the options to a re-direction in the [SERVICES_EXEC] section. For more information, see COM Connector and [SERVICES_EXEC].
Component Engine Connectors
Connector Database Connector Parameters More Information
SOP SOAP USYS$SOP_PARAMS

SOAP Connector Options

Database Connector Settings
Connector Database Connector Parameters More Information
LDP LDAP USYS$LDP_PARAMS LDAP Connector Options
DB2 DB2 USYS$DB2_PARAMS DB2 Connector Options
INF Informix USYS$INF_PARAMS Informix Connector Options
MSS Microsoft SQL Server USYS$MSS_PARAMS MSS Connector Options
MQL MySQL USYS$MGL_PARAMS MySQL Connector Options
OCx ODBC USYS$ODB_PARAMS ODBC Connector Options
ORA Oracle USYS$ORA_PARAMS Oracle Connector Options
PGS PostgreSQL USYS$PGS_PARAMS PGS Connector Options
SEQ Sequential

N/A

N/A
SLE SQLite USYS$SLE_PARAMS SLE Connector Options
SYB Sybase USYS$SYB_PARAMS Sybase Connector Options
TXT Text USYS$TXT_PARAMS

N/A

Using Oracle Connector

The following example assignment file specifies that the Oracle connector version U6.1 is used, and that its parameters are open cursors 40, dpa:

[DRIVER_SETTINGS]
  ORA = U6.1
  USYS$ORA_PARAMS = open cursors 40, dpa

Using the SOAP Connector for Call-Out

The following example assignment file specifies that the SOAP connector version U1.0 is used, and that its parameters are to be used by all components that use the SOAP connector (SOP) executing call-out to Web services. The call-out components will use the current user’s Microsoft Internet Explorer settings to identify the proxy server, which will be supplied with user name user1 and password password1 for Basic authentication by the proxy server.

[DRIVER_SETTINGS]
  SOP U1.0
  USYS$SOP_PARAMS = puser=user1, ppass=password1, scheme=B

Related Topics