1. Ed Van Haren
  2. PowerBuilder
  3. Wednesday, 18 August 2021 19:07 PM UTC

Can PB 19 R2 client / server desktop app connect to a SQLMI database on the cloud? Is there sample code? Or do / should we upgrade to a newer version to get this capability.

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 18 August 2021 20:06 PM UTC
  2. PowerBuilder
  3. # 1

Hi Ed,

Microsoft provides some documentation on how to connect on-premise apps to SQLMI (refer to the Connect from on-premises subsection): https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/connect-application-instance

The other thing you may want to consider is converting your client/server app into a cloud app using the new PowerServer 2021 option.  Then you can host your PowerBuilder app in Azure together with SQLMI.  It generally takes a few days to few weeks of work to convert.  Here is a 5-minute product tour: https://www.appeon.com/products/powerserver-tour

Best regards,
Armeen

Comment
  1. Ed Van Haren
  2. Wednesday, 25 August 2021 19:23 PM UTC
Thanks for the reply. I looked into PowerServer and it looked like a good approach. Unfortunately, PowerServer does not support DB2 (most of our C/S PB apps connect to DB2). I will post another question on ideas for the best way to move our apps to the cloud (since not really related to this topic).
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Wednesday, 25 August 2021 20:42 PM UTC
Yes, sorry DB2 not supported. You're very welcome.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 18 August 2021 19:53 PM UTC
  2. PowerBuilder
  3. # 2

Hi Ed;

  AFAIK, Managed Instances of Azure SS are the same as " Enterprise Edition " SS. Thus, just use it's IP Address for accessing the DBMS instance vs using a DNS server name on your local network.  HTH

Regards ... Chris

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.