Recognizing database failover with PB8.0 and Oracle 8i

[jwalacha]

I have a PB8.0 Build 6028 application that is connected to an Oracle8i database with Oracle Failsafe installed.

I would like my PB application to acknowledge that the database is failing over, and therefore not lose the SQLCA connection to the database during the time it is failing over to another machine.

Following is the code that I use while connecting to the DB.

SQLCA.DBMS = "O84 Oracle8/8i (8.x.4+)"
SQLCA.LogPass = ls_password
SQLCA.LogId = ls_userid
SQLCA.ServerName = "MIX"
SQLCA.AutoCommit = False
SQLCA.DBParm =
"QualifyPublic=1,PBUseProcOwner='Yes',
PBCatalogOwner='MIXUSER',SvrFailover='Yes',FoDelay=10000,
FoDialog='Yes',FoRetryCount=10"

Currently, the application disconnects from the database when the database fails over and gives me Datawindow errors.

Does anyone have any suggestions?

Thanks,

Jay.