HomePowerBuilderAppeon Documentation Center

Configuring ODBC data source with PostgreSQL demo database

To set up the ODBC data source with the PostgreSQL demo database,

  1. Install PostgreSQL 12 and PostgreSQL ODBC driver (both 32-bit and 64-bit).

    Make sure the Command Line Tools component is selected during the PostgreSQL 12 installation.

  2. Restore the PostgreSQL demo database file. For example, 

    "C:\Program Files\PostgreSQL\12\bin\pg_restore" --host=127.0.0.1 --port=5432 --username="postgres" --clean --if-exists --dbname=PBDemo --verbose "C:\DB\pbpostgres2022.dmp"

  3. Create the ODBC data source that includes the following settings.

    Data Source: PB Postgres V2022R3

    Database: PBDemo

    Server: [IP address for the database]

    Username: [user name for the database, postgres, by default]

    Port: [port number for the database, 5432, by default]

    Password: [password for the database, postgres, for example]



Prev  Up  Next
Installing PowerBuilder demo applications and database  Home  Configuring ODBC data source with SQL Anywhere demo database