FailoverPartner – PB Docs 126

FailoverPartner database parameter

Description

Specifies the name
of a mirror server, allowing you to maintain database availability
if a failover event occurs.

Controls

  • SNC SQL Native Client for Microsoft SQL Server

Syntax

Parameter

Description

value

Specifies the name of a mirror server.

Default

None

Usage

When failover occurs, the existing PowerBuilder connection to
SQL Server is lost. The SNC driver releases the existing connection
and tries to reopen it. If reconnection succeeds, PowerBuilder triggers
the DBNotification event. The following conditions must be satisfied
for PowerBuilder to trigger the failover event:

  • The FailoverPartner DBParm is supplied at connect time

  • The SQL Server database is configured for mirroring

  • PowerBuilder is able to reconnect successfully
    when the existing connection is lost

When failover occurs:

  • PowerBuilder returns
    an error code (998) and triggers the DBNotification event with
    notification type DBFailover!

  • Existing cursors cannot be used and should be closed

  • Any failed database operation can be tried again

  • Any uncommitted transaction is lost. New transactions
    must be started

Examples

The following example sets the name of a mirror server
for failover events:

  • Database
    profile

    Type the mirror server name in the Failover Partner text box
    on the System page of the Database Profile Setup dialog box.

  • Application

    Type the following in code:


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x