1. Richard Shakour
  2. PowerBuilder
  3. Friday, 13 December 2019 19:05 PM UTC

I am trying to connect two separate PB Classic applications.

One is installed locally on my computer and the other is on a remote web based server.

I want to call a function from the local PB application in the Remote PB Application and pass arguments including a DW.

The idea is to send the remote application a DW, have it do some processing and then return the processed DW.

What is the simplest and easiest way to approach this.  I don't need details just in general how does one accomplish this.  i.e. A local PB application calling a function in a remote PB application.

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Friday, 13 December 2019 20:52 PM UTC
  2. PowerBuilder
  3. # 1

Hi Richard,

Use PB 2019 R2 to convert the PowerScript function of the remote app into a C# Web API.  It can automatically convert 80+% of non-visual code to C# and supports the DataStore with most of its functionality.  Currently, this feature is in beta, but we have gotten great feedback from customers.

Then from your client app you call the C# Web API using the new RESTClient object.

Here are some useful tech resources:

By the way, PowerServer Web apps also support the RESTClient.  You just need to upgrade to PowerServer 2020, which is releasing this month.

Regards,
Armeen

Comment
  1. Armeen Mazda @Appeon
  2. Monday, 16 December 2019 06:22 AM UTC
Yes, good point. A supported database is required and the 4 databases you listed are what is currently supported.

PowerBuilder 2019 R2 Universal Edition will be bundling PowerServer 2020.
  1. Helpful
  1. Miguel Leeuwe
  2. Wednesday, 18 December 2019 08:19 AM UTC
Thank you. I do feel PB with snapobjects and powerserver should be supporting MORE database connections, even being through ODBC / JDBC. One of the things that makes PB a great choice, has always been the many many supported database connections. Right now that's no longer the case, though hopefully things will improve within a few years?
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Wednesday, 18 December 2019 17:29 PM UTC
The .NET DataStore and SnapObjects open-source framework support SQL Server, Oracle, Postgres, and SQL Anywhere. We are planning to support some or all of the following databases: Azure SQL, Amazon Aurora, MongoDB, and MySQL. Is their other database you think is very important to support?
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 13 December 2019 20:25 PM UTC
  2. PowerBuilder
  3. # 2

Hi Richard;

  FWIW:  http://chrispollach.blogspot.com/2019/12/socket.html

Food for thought.  ;-)

Regards ... Chris

Comment
  1. Miguel Leeuwe
  2. Sunday, 15 December 2019 21:17 PM UTC
Very useful !
  1. Helpful
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.