Archives: Articles

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…

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…

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…

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…

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…

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…

Start session manually by code – PB Docs 2022

Start session manually by code By default, the user session is automatically created when the application starts; and the session includes no token. For the session to include the token, the session must be started manually by code instead of automatically. To start the session manually by code, Step 1: Select the “Dynamic session parameters”…