Path: g2news2.google.com!postnews.google.com!17g2000prr.googlegroups.com!not-for-mail
From: powell lam <powell...@gmail.com>
Newsgroups: sybase.public.powerbuilder.database
Subject: Client automatic reconnection with Sybase HA
Date: Tue, 3 May 2011 20:11:20 -0700 (PDT)
Organization: http://groups.google.com
Lines: 21
Message-ID: <20848155-de3b-4290-89b2-408841f2a1a2@17g2000prr.googlegroups.com>
NNTP-Posting-Host: 130.214.25.253
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1304478680 6994 127.0.0.1 (4 May 2011 03:11:20 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 4 May 2011 03:11:20 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: 17g2000prr.googlegroups.com; posting-host=130.214.25.253; posting-account=ZhlmfQoAAADA8GL6i0Rh1Hzcw25P1Viy
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1;
 Trident/4.0; GTB6.6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR
 3.0.4506.2152; .NET CLR 3.5.30729),gzip(gfe)


Environment:
PB 11.5

Sybase ASE 15
OS:Windows XP
MSCS Cluster Active=Active configuration

I have PB front end application having sybase servers with H/A option
enabled. During failover my PB application failed to reconnect
automatically to the secondary server. I have kept 'hafailover' key in
my
sql.ini file which points to my secondary companion server.
if i use 'isql -q' from command prompt, it works fine.

For my PB application, it works okay for using OBBC connection.  But
if change to use native driver, itcouldn't able to switch
automatically and reconnect to secondary server after failover
happens.

Any setting on front-end if use native driver ?