Installing PowerBuilder demo applications and database
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
computerDatabase 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,
1"C:Program FilesPostgreSQL12inpg_restore" --host=127.0.0.1 --port=5432 --username="postgres" --clean --if-exists --dbname=PBDemo --verbose "C:DBpbpostgres2021.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]
