PB Docs 2022

Troubleshooting – PB Docs 2022

Troubleshooting Contents Unable to connect to remote SQL Server database over Named Pipes even though local database can be connected Using the PostgreSQL CA certificate for SSL connection, the verification fails Communication error when connecting with the Informix database Document get from Powerbuilder help Thank you for watching.

Starting the database – PB Docs 2022

Starting the database Step 1: Download the database file (pbdemo2022_for_postgresql.zip) from https://github.com/Appeon/PowerBuilder-Project-Example-Database. Step 2: Restore and run the database in the management tool for PostgreSQL. Select Windows Start menu | PostgreSQL 12 | pgAdmin 4. pgAdmin 4 is a Web application. If pgAdmin 4 cannot run in Internet Explorer (the default Web browser in Windows…

Mapping the transaction object – PB Docs 2022

Mapping the transaction object At app runtime, PowerServer determines which database connection cache to use according to the transaction object in use (the connection string in the PowerScript will be ignored). By default, the SQLCA transaction object will be automatically mapped with the cache. But if there is more than one transaction object existing in…

Preparations – PB Docs 2022

Preparations Before making changes to the PowerBuilder client app, let’s follow the steps below to make sure 1) the PowerBuilder application can run successfully, 2) the app has been deployed as an installable cloud app successfully, and 3) the PowerServer C# solution (including the built-in JWT server) has been successfully generated. In this tutorial, we…

(Optional) Verifying the Web APIs – PB Docs 2022

(Optional) Verifying the Web APIs After PowerServer Web APIs is deployed to the IIS web site, the IIS process manager will automatically launch the Web APIs. (Make sure ASP.NET Core Hosting Bundle has been installed to IIS.) Although you don’t need to start the Web APIs manually, it is recommended that you verify the Web…

Verifying the Web APIs – PB Docs 2022

Verifying the Web APIs After the Web APIs is deployed to the IIS website, the IIS process manager will automatically launch the Web APIs. (Make sure ASP.NET Core Hosting Bundle has been installed to IIS.) Although you don’t need to start the Web APIs manually, it is recommended that you verify the Web APIs can…

Verifying the configuration – PB Docs 2022

Verifying the configuration Now let’s run the PowerServer Web APIs and verify that the requests are forwarded successfully from the reverse proxy server to the PowerServer Web APIs. In order to view the detailed log information, let’s directly start the PowerServer Web APIs as a console application in the local development environment, using either of…

Installing Nginx – PB Docs 2022

Installing Nginx Step 1: Download and install Nginx from the CentOS’s default software repositories. Make sure the machine can connect to Internet during the download and installation process.

During the download and installation process, you might be prompted to enter the password for your user account, or enter y to confirm that you want…

Purpose – PB Docs 2022

Purpose In this section, we will modify the PowerBuilder application source code and the PowerServer project settings to achieve the following results: Gets the user credential from the application login window, then authenticates it with the Amazon Cognito User Pools and gets an identity token. Uses the identity token to access data from the PowerServer…

Installing ASP.NET Core Hosting Bundle – PB Docs 2022

Installing ASP.NET Core Hosting Bundle ASP.NET Core Hosting Bundle is required if you want the IIS process manager to automatically launch the ASP.NET Core application (such as PowerServer Web APIs) deployed to the IIS website. Download and install ASP.NET Core Hosting Bundle 6.0. The version of hosting bundle must match with the version of .NET…