You must select the database provider and agree to the driver license terms as the driver must be downloaded from the NuGet site to the development PC and PowerServer later. Unlike the traditional client/server app which directly connects with the database through a local driver, the installable cloud app relies on the PowerServer Web APIs and the .NET Core database provider to connect with the database.
To agree to download the database driver:
-
Select the Database page in the PowerServer project painter.
-
Select the database provider from the Provider list.
-
In the Database driver option group, click the View License Terms link to view the license first and then select the option "I have read and agree to the license ...". You need to select this option for each database type used in the application.
Note
When the option "I have read and agree to the license ..." is selected, the corresponding driver package will be downloaded automatically to the development PC and the PowerServer whenever necessary.
If you select DB2, MySQL, Oracle, or Informix from the Provider listbox, you will be asked to either specify an existing .NET Core driver on the local machine or allow PowerBuilder to download and install the required driver for you. The packages will be downloaded to %USERPROFILE%\.netdbdrives\; they will be automatically loaded when the database connection is created in the PowerBuilder IDE.
Note
You can manually download the following .NET Core driver or have PowerBuilder automatically download the driver for you from the NuGet website:
-
MySql.Data 8.0.32.1 for MySQL
-
Oracle.ManagedDataAccess.Core 3.21.100 for Oracle
-
IBM.Data.DB2.Core 3.1.0.600 for Informix and DB2
Note
If you select to allow PowerBuilder to download the driver, make sure the development PC and the PowerServer can connect to the NuGet site: https://www.nuget.org.
