Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved PB application and DB in availability groups

  1. Advice
0
Votes
Undo
  1. Ganesan Rajan
    Ganesan Rajan
  2. PowerBuilder
  3. Thursday, 19 September 2019 08:46 AM UTC

Hi Experts,

Just a brief about our product. 

We use PowerBuilder 2017.

Our app connects to SQL server 2012/2016 via SQL native client 2012 ole db (sqlncli11.dll).

Now I have been asked a question. 

Does your product support availability groups?

Basically they will have their databases in availability groups. My understanding is that they may do it for disaster recovery or to provide always ON connection to the respective applications.

Can you please help me whether any one of you have connected your application to a database that is in availability groups? Have you set mutisubnet failover in your connection string?

 

Thanks a ton,

Ganesan R

 

  1. PowerBuilder (Appeon)
PB2017-R3/PB2019 Not working with GitHub Enterpri...
Old powerbuilder question
Responses (2)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 19 September 2019 13:34 PM UTC
  2. PowerBuilder
  3. # 1

I believe you just have to use the DNS name of the availability group listener in your connection string where you normally would put the database server name.

Comment
There are no comments made yet.
Ganesan Rajan
Ganesan Rajan Accepted Answer Pending Moderation
  1. Thursday, 3 October 2019 09:47 AM UTC
  2. PowerBuilder
  3. # 2

Thanks Roland. We shall try it.

Regards,

Ganesan R

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.