PowerServer 2022 R2 Help
Task 2: Building with commands

Step 1: To build and deploy the PowerServer project using the command-line tool (instead of within PowerBuilder IDE), install the following software.

The PBAutoBuild220.exe tool can automate the entire build and deploy process outside PowerBuilder (without needing any PowerBuilder license).

Step 2: Prepare the database driver if the DB2, MySQL, Oracle, or Informix database connection is required.

If the DB2, MySQL, Oracle, or Informix database connection is used and if the corresponding database driver has not been downloaded yet, you will need to manually download the database driver from the NuGet website.

Tips:

1) To unzip a NuGet package, you can change the file extension from .nupkg to .zip, and then unzip the file.

2) If you have PowerBuilder IDE installed on another machine, you can have PowerBuilder IDE download and install the driver automatically, and then you can directly copy the folder from there (without needing to manually download the driver).

3) If there is any inconsistency between the document and the product message regarding the minor version number of the driver, please follow the product message as the authoritative source.

4) Make sure that drivers are copied to the specified location, so that they can be automatically loaded by PBAutoBuild220.exe.

MySQL

Step 1: Create the following directory under %USERPROFILE%: %USERPROFILE%\.netdbdrives\mysql\8.0.32.1.

Step 2: Download MySql.Data 8.0.32.1 and the license file.

Step 3: Unzip the file, and copy MySql.Data.dll from MySql.Data.8.0.32.1\lib\netstandard2.1\ to %USERPROFILE%\.netdbdrives\mysql\8.0.32.1.

Oracle

Step 1: Create the following directory under %USERPROFILE%: %USERPROFILE%\.netdbdrives\oracle\3.21.100.

Step 2: Download Oracle.ManagedDataAccess.Core 3.21.100 and the license file.

Step 3: Unzip the file, and copy Oracle.ManagedDataAccess.dll from Oracle.ManagedDataAccess.3.21.100\lib\netstandard2.1\ to %USERPROFILE%\.netdbdrives\oracle\3.21.100.

Informix / DB2

Step 1: Create the following directory under %USERPROFILE%:

For Informix: %USERPROFILE%\.netdbdrives\informix\3.1.0.600

For DB2: %USERPROFILE%\.netdbdrives\db2\3.1.0.600

Step 2: Download IBM.Data.DB2.Core 3.1.0.600 and the license file.

Step 3: Unzip the file.

Step 4: Copy the IBM.Data.DB2.Core.dll file from IBM.Data.DB2.Core.3.1.0.600\lib\netstandard2.1\ to %USERPROFILE%\.netdbdrives\informix\3.1.0.600 or %USERPROFILE%\.netdbdrives\db2\3.1.0.600.

Step 5: Copy the clidriver folder from IBM.Data.DB2.Core.3.1.0.600\buildTransitive to %USERPROFILE%\.netdbdrives\informix\3.1.0.600 or %USERPROFILE%\.netdbdrives\db2\3.1.0.600.