SvrFailover

Description

Specifies whether you want DataWindow Designer to recognize and participate in failover to a designated backup database server if the current database server goes down.

NoteWhen to specify SvrFailover You must specify the SvrFailover parameter before connecting to the database.

Applies to

Syntax

SvrFailover='value' 

Parameter

Description

value

Specifies whether you want DataWindow Designer to recognize and participate in failover to a designated backup database server if the current database server goes down. Values are:

  • No (Default) DataWindow Designer should not recognize or participate in failover.

  • Yes DataWindow Designer should recognize and participate in failover.

Default

SvrFailover = 'No'

Usage

Both Oracle and Sybase support database server failover in Oracle Version 8.1.5 or later and Adaptive Server 12 or later. For information about how to configure failover for these database servers, see your Oracle or Adaptive Server documentation. To avoid losing your DataWindow Designer database connection (as the result of a timeout) when a failover takes place, set the SvrFailover parameter so that DataWindow Designer recognizes and participates in the database server failover.

Oracle also allows you some control over the failover process. Three additional parameters allow you to specify the number of times you want the database server to which you are connected to attempt a failover, how long to wait between failover attempts, and whether DataWindow Designer should display a runtime dialog box indicating when a failover occurs.

This parameter cannot be set dynamically. The value set when the connection is made remains in effect until it is disconnected.

Examples

Example 1

To tell DataWindow Designer to recognize and participate in failover:

See also