Common Connection Properties

Connection String Options

The following is the list of connection strings properties relatives to the majority of the connectors

Firewall Settings

Firewall Server

Specify a firewall name or IP address to authenticate requested connections, if necessary.

If this property is set to a domain name, a DNS request is initiated and the name is translated to the corresponding IP address.

Firewall Password

A password, if authentication is required to connect through a firewall.

If FirewallServer is specified, the FirewallUser and FirewallPassword properties are used to connect and authenticate to the given firewall.

Firewall Port

The TCP port for the firewall FirewallServer -- see the description of the FirewallServer option for details.

Note that the provider sets the FirewallPort to the default port associated with the specified FirewallType. See the description of the FirewallType option for details.

Firewall Type

The type of firewall to connect through.

The applicable values are:

Firewall Type Default Firewall Port:

TUNNEL 80

SOCKS4 1080

SOCKS5 1080

Firewall User

The user name to authenticate with the firewall.

If the FirewallServer is specified, the FirewallUser and FirewallPassword properties are used to connect and authenticate against the firewall.

Proxy Settings

Proxy Auth Scheme

The proxy server authorization scheme (default: BASIC).

This value may be BASIC, DIGEST, NONE, NTLM, NEGOTIATE or PROPRIETARY.

Proxy Auto Detect

This indicates whether to use the default system proxy settings or not. Set ProxyAutoDetect to FALSE to use custom proxy settings. This takes precedence over other proxy settings.

Proxy Password

A password, if authenticating with a proxy server.

If the ProxyServer is specified, the ProxyUser and ProxyPassword properties are used to connect and authenticate against the firewall.

Proxy Port

The TCP port for the proxy ProxyServer (default: 80).

Proxy Server

If a proxy server is given, then the HTTP request is sent to the proxy instead of the specified server.

If this property is set to a domain name, a DNS request is initiated and the name is translated to the corresponding address.

Proxy SSL Type

The SSL type to use when connecting to the proxy server (default: AUTO).

This value may be AUTO, ALWAYS, NEVER, or TUNNEL.

Proxy User

A user name, if authentication is to be used for the proxy.

If a ProxyServer is specified, the ProxyUser and ProxyPassword options are used to connect and authenticate against the firewall.

Connector Logs

Logfile

A path to the log file.

Max log File Size

A string specifying the maximum size in bytes for a log file (for example, 10 MB). When the limit is hit, a new log is created in the same folder with the date and time appended to the end.

Verbosity

The verbosity level that determines the amount of detail included in the log file.

Default: 1

The verbosity level determines the amount of detail that the provider reports to the Logfile. Verbosity levels from 1 to 5 are supported. These are described below:

1 - Setting Verbosity to 1 will log the query, the number of rows returned by it, the start of execution and the time taken, and any errors.

2 - Setting Verbosity to 2 will log everything included in Verbosity 1, cache queries, and HTTP headers.

3 - Setting Verbosity to 3 will additionally log the body of the HTTP requests.

4 - Setting Verbosity to 4 will additionally log transport-level communication with the data source. This includes SSL negotiation.

5 - Setting Verbosity to 5 will additionally log communication with the data source and additional details that may be helpful in troubleshooting problems. This includes interface commands.

The Verbosity should not be set to greater than 1 for normal operation. Substantial amounts of data can be logged at higher verbosities, which can delay execution times.