Table of Contents
You can create database connection caches for the following databases in the IDE > Database Configuration dialog or in the PowerServer:
-
IBM DB2 UDB 11.x
-
Informix 12.x or 14.x
-
MySQL 5.6, 5.7, or 8.0
-
Oracle 12c, 18c, 19c, 21c, or 23c
-
PostgreSQL 12, 13, 14, or 15
-
SQL Server 2016, 2017, 2019, or 2022, or Azure SQL Database (latest SQL Server engine as at September 2020)
-
ASE (ODBC) 16.0
Different from the PowerBuilder runtime environment where the ASE database is connected using the native driver, ASE databases can only be connected using the ODBC driver in the PowerServer runtime environment. This driver change has caused some differences. See ASE database for more details.
-
SQL Anywhere (ODBC) 16 (16.0.0.2043 or later) or 17
If SQL Anywhere is on a different machine from PowerBuilder, make sure to enable the connection pooling setting in the ODBC driver. Connection pooling is enabled by default if SQL Anywhere is on the same machine as PowerBuilder.
It is recommended to create and start the SQL Anywhere service in Sybase Central, when Web APIs is running in a production environment. For more, refer to here.
Note
SQL Anywhere and ASE databases are connected using the ODBC driver for .NET Core. The other databases are connected using the native driver for .NET Core.
Tutorial: Connecting to the Database provides step-by-step instructions for how to create the caches for different databases in the Database Configuration dialog.
