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

Resolved PB2017 connect to SQL as a service

  1. Advice
0
Votes
Undo
  1. Javier Garat
    Javier Garat
  2. PowerBuilder
  3. Wednesday, 23 October 2019 19:45 PM UTC

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

  1. Cloud
  2. PowerBuilder (Appeon)
  3. SQL
Web Service using httpclient object
PB 2017 R3 couple problem with github
Responses (2)
mike S
mike S Accepted Answer Pending Moderation
  1. Wednesday, 23 October 2019 20:56 PM UTC
  2. PowerBuilder
  3. # 1

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
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 23 October 2019 20:36 PM UTC
  2. PowerBuilder
  3. # 2

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.
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.