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

Resolved Connecting to SQLMI on the cloud from PB 19R2 C/S app

  1. How-to
0
Votes
Undo
  1. Ed Van Haren
    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.

Powerbuilder2017R2 is not working with outlok 64 b...
Moving PB C/S apps to the cloud
Responses (2)
Armeen Mazda @Appeon
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
Ed Van Haren
  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
Armeen Mazda @Appeon
  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
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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.