Working with Database Connections – PB Docs 2022
Working with Database Connections Contents Overview Supported database connection options Techniques for supporting various connection scenarios DB connection differences (C/S app vs. installable cloud app) Supported database types & versions ASE database Supported DBParm properties Enabling long connections Common scenarios where long connections should be enabled Configuring database caches Creating database caches in the IDE…
Running the installable cloud application – PB Docs 2022
Running the installable cloud application Step 1: Make sure your computer can connect to the NuGet site (https://www.nuget.org). NuGet packages must be downloaded first in order to run the PowerServer Web APIs. Step 2: Click the Run Project button () in the toolbar. This will run the PowerServer Web APIs on the local machine, including…
Supports Strict encryption for SQL Server – PB Docs 2022
Supports Strict encryption for SQL Server The “Strict” encryption type is added to support TDS 8.0 in SQL Server 2022. You can select the Strict encryption when configuring the SQL Server database connection in the IDE (PowerServer project painter > Database page > Basic tab > More button > Advanced dialog). Or specify “encrypt=Strict” in…
Server – PB Docs 2022
Server Contents File server To host the PowerServer Web APIs (and the client app, launcher, and runtime), you can consider the following environments (any version within the support period is supported): Windows IIS For how, refer to Hosting Web APIs in IIS. Windows/Linux Kestrel (with or without a reverse proxy server) For how, refer to…
Configuring the Web API URL – PB Docs 2022
Configuring the Web API URL Now you will need to specify the Web API URL in the client app. Step 1: Go to the client app folder (for example, “googlecharts_cloud” for Example Graph App, “salesdemo_cloud” for Example Sales App), open the apprun.json file in a text editor. Step 2: Modify the value of “web_api”. The…
Running the installable cloud app – PB Docs 2022
Running the installable cloud app Run the application in a Web browser when it is the first time to run the app. The user can input the application URL http://[ServerIP]/[AppName] in a Web browser to access the application. The IP address should point to the server where the app files are installed. Note: IE and…
Using SnapDevelop – PB Docs 2022
Using SnapDevelop You can also use the Docker method in the SnapDevelop IDE to publish and deploy the PowerServer Web API to Docker. Step 1: Open the PowerServer C# solution in SnapDevelop. Click the Open C# Solution in SnapDevelop button () in the toolbar to launch the PowerServer C# solution in SnapDevelop. Or go to…
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…
Task 1: Exporting the build file – PB Docs 2022
Task 1: Exporting the build file Contents Preparing the environment Creating a launcher package Exporting the build file Modifying the build file Document get from Powerbuilder help Thank you for watching.