connecting to ASE cluster from a Powerbuilder application

[Phathutshedzo]

I have a Powerbuilder application (developed in powerbuilder 11.5)
that is connected to a specific instance of ASE with a specific port
and instance details. we are upgrading databases and would like to
explore the cluster functionality of ASE 15.0.3 EBF 16748 cluster
edition and the hosts are running off a linux machine.

This is what we are trying to achieve from withing the application:-

we would to connect to whatever host is online depending on the existing
cluster ie. if it has cluster named asecluster1 and it has multiple
hosts... hostsa / hostsb / hostsc ... i would like to establish a
connecting to asecluster1 and depending on the host that is online it
connects to that specific host. should the application connect to
hosta and host a falls over, the cluster should re-route the
connection to hostb .. all this must take place dynamically without
hardcodng this in the application itself.

has anyone attempted this or can anyone shed some light on how to
achieve this?

In the beginning....

 

[miguelleeuwe]

very interesting.
Though I'd like to help you I've got no idea about this.

this might sound mighty stupid but:
----------------------------------
would a solution be to simply try to connect from powerbuilder, using several connection profiles with the different hosts you have and stop trying to connect once you found the one that connected (the one that's online)????

Maybe you'll get more help on a sybase Database forum, since it sounds like DBA stuff to me.

just trying,



regards,
Miguel L.

 

[miguelleeuwe]

found some information at:

http://www.sybase.com/products/databasemanagement/adaptiveserverenterprise/ase-cluster-edition

in the second tab 'implementation services', you'll see:
-----------------------------
Jump start your deployment
Migrating to ASE Cluster Edition makes good business sense for IT professionals. The ASE 15 Cluster Edition Implementation Service Package, delivered by Sybase consulting experts, assesses the foundation of your technical environment and guides the installation and deployment of the product on your clustered hardware using industry best practices.

Hope it helps.

regards,
Miguel L.