-
You can connect and interact with the PostgreSQL database using the PowerBuilder ADO.NET database interface. (In previous versions, you normally connect and interact with the PostgreSQL database using the PowerBuilder ODBC database interface.)
The ADO.NET data provider for PostgreSQL (npgsql.dll) is automatically included and installed with PowerBuilder.
A number of runtime files (including Appeon.DB.PostgreSql.dll) are required for supporting the connection at PowerBuilder runtime.
For more information, refer to ADO.NET PostgreSQL in Connecting to Your Database.
-
You can also connect with other database types via ADO.NET by providing the ADO.NET data provider as a custom driver in PowerBuilder.
So far, PowerBuilder has enhanced its ADO.NET database interface for the following data providers: ODBC, Oracle, PostgreSQL, and SQL Server. For other data providers (such as MySQL, Teradata etc.), you can provide them as a custom driver in PowerBuilder. Custom driver means the driver has not been predefined or preprocessed by PowerBuilder. Therefore, PowerBuilder may not fully work with the custom driver if: 1) The driver is not implemented according to established standards; 2) The driver and its required dependencies are not fully provided. For example, if the data set returned by the driver differs from the expected data set standards, parsing may fail, resulting in incorrect data being returned.
You can specify a download URL or a local directory of the custom driver and PowerBuilder will try to load and parse the driver according to the ADO's standard interfaces and common data types.
For more information, refer to ADO.NET custom driver in Connecting to Your Database.
