1. Javier Garat
  2. PowerBuilder
  3. Wednesday, 23 October 2019 19:45 PM

Dear Appeon Community,

I need information, restrictions, limitations that we should consider regarding an application developed in Powerbuilder 2017 can connect to databases in the cloud (SQL as a Service). This application will be hosted on Windows 2010.

Any information I will be grateful.

Thanks for your help.

Regards,

Javier

mike S Accepted Answer Pending Moderation
  1. Wednesday, 23 October 2019 20:56 PM
  2. PowerBuilder
  3. # 1
0
Votes
Undo

If you use Azure sql (which is sql server as a service), then you simply connect like a local database.  Same thing if you host sql server in a VM on aws, azure, or where ever.

You should use encryption in these cases.  azure sql has everything setup already so you just need to use the encryption setting in your connection string.

 

 

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 23 October 2019 20:36 PM
  2. PowerBuilder
  3. # 2
0
Votes
Undo

Hi Javier;

     FWIW:   I have SS2015 / SS2017 running in an EC2 Instance on AWS. Using "Elastic" addressing, I know the IP static address and then just need to set the Port number from my PB IDE and/or Apps (including PowerServer). Works like a charm with that Cloud provider for me under that configuration.

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.