The PowerBuilder demo applications and database are installed by default, unless you de-selected the PowerBuilder Tutorial, Demo Database, and Code Examples components during installation.
If the PowerBuilder demo applications and database are not installed during the PowerBuilder installation process, you can manually download the demo app source code and database from the Appeon website later: Example App, Example Graph App, Example Sales App and the SQL Anywhere database or PostgreSQL database file.
But before you can successfully run the downloaded demo application, you will need to set up an ODBC data source to connect with the demo database.
To set up the ODBC data source with the SQL Anywhere demo database,
-
Install SQL Anywhere 17.
-
Create the ODBC data source that includes the following settings.
Data Source Name: PB Demo DB V2021
User ID: dba
Password: sql
Action: Start and connect to a database on this computer
Database file: [path to the database file]
Database name: pbdemo2021
Server name: PBDemoDB2021
Start line: [path to the SQL Anywhere engine]
To set up the ODBC data source with the PostgreSQL demo database,
-
Install PostgreSQL 12 and PostgreSQL ODBC driver (32-bit).
Make sure the Command Line Tools component is selected during the PostgreSQL 12 installation.
-
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\pbpostgres2021.dmp"
-
Create the ODBC data source that includes the following settings.
Data Source: PB Postgres V2021
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]
