Supported database types

Table of Contents

ASE database

You can create database connection caches for the following databases in the Database Configuration window or in the PowerServer C# solution:

  • Adaptive Server Enterprise (ODBC) 16.0

    ASE databases can only be connected using the ODBC driver in the PowerServer runtime environment. This is different from the PowerBuilder runtime environment where the ASE database is connected using the native driver. See the next section for the differences caused by this driver change.

  • Informix 12.x or 14 (Beta feature) *

    PowerBuilder and/or PowerServer will automatically download the required driver (IBM.Data.DB2.Core 2.2.0.100) from https://www.nuget.org, or you will be asked to specify the location of the driver if https://www.nuget.org cannot be connected.

    * Beta means the feature has not been fully tested, has known bugs, and does not receive standard technical support. We will collect reported bugs and try to address in a future version.

  • MySQL 5.6, 5.7, or 8.0

    PowerBuilder and/or PowerServer will automatically download the required driver (MySql.Data 8.0.25) from https://www.nuget.org, or you will be asked to specify the location of the driver if https://www.nuget.org cannot be connected.

  • Oracle 12c, 18c, or 19c

    PowerBuilder and/or PowerServer will automatically download the required driver (Oracle.ManagedDataAccess.Core 2.19.110) from https://www.nuget.org, or you will be asked to specify the location of the driver if https://www.nuget.org cannot be connected.

  • PostgreSQL 11.3, 12, or 13

  • 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.

  • SQL Server 2016, 2017, or 2019

SQL Anywhere and ASE databases can be connected using the ODBC driver only. The other databases are connected using the native database driver.