PowerServer uses the .NET Core data provider to connect with the database. The corresponding database drivers will be downloaded as NuGet packages from www.nuget.org. For the download and install to happen automatically in the development PC and the PowerServer, you need to make a few selections in the PowerBuilder IDE. The later section Download the database driver has detailed instructions.
-
For PostgreSQL, SQL Server, SQL Anywhere, and ASE database, you must read and agree to the driver license in the PowerBuilder IDE. After that, the corresponding .NET Core driver will be downloaded whenever necessary in an automatic way.
For databases (such as SQL Anywhere and ASE) that PowerServer connects through ODBC, besides the .NET Core driver, you will also need to manually install the ODBC driver and create the ODBC data source in the development PC and the PowerServer.
-
For DB2, Informix, MySQL, and Oracle database, you must download the .NET Core driver by yourself or allow PowerBuilder to download and install the driver for you. If you select to allow PowerBuilder to download the driver, the corresponding .NET Core driver will be downloaded whenever necessary in an automatic way.
Walkthrough: Connecting to the Database provides step-by-step instructions for how to download the driver and create the cache for each supported database type in the PowerBuilder IDE.
