FoRetryCount

Description

Specifies the number of times you want PowerBuilder to try to fail over to an another database server if the current database server goes down.

When to specify FoRetryCount

You must specify the FoRetryCount parameter before connecting to the database.

Applies to

O90 Oracle9i

O10 Oracle 10g

ORA Oracle (for 11g and later)

Syntax

FoRetryCount='value'

Parameter

Description

value

Specifies the number of times you want PowerBuilder to try to fail over.


Default value

FoRetryCount='10'

Usage

You can enter a failover retry value only if you have enabled failover.

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

Examples

To tell PowerBuilder to try 20 times to fail over:

  • Database profile

    Enter the value 20 in the Retry Count box on the Network page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

    SQLCA.DBParm="FoRetryCount='20'"

See also

SvrFailover