1. Yakov Werde
  2. PowerBuilder
  3. Friday, 2 December 2022 17:56 PM UTC

Postgre local server installed and functioning. Configured and connected to ODBC 32 bit profile.

PB 2022 Installer does not load PostgreSQL odbc profile into drop down listbox.  Cannot install Demo DB scripts during installation

Seems like a 'bug'

Yakov Werde Accepted Answer Pending Moderation
  1. Friday, 2 December 2022 20:33 PM UTC
  2. PowerBuilder
  3. # 1

I think these should be completed before installing IDE with demo db - but not sure

 

pg_restore: from TOC entry 10; 2615 94468 SCHEMA public postgres
pg_restore: error: could not execute query: ERROR: schema "public" already exists
Command was: CREATE SCHEMA public;

 

pg_restore: warning: errors ignored on restore: 1

 

Seems like it completed successfully

 

PB sees them too, albeit with the schema owner name

Comment
  1. Chris Pollach @Appeon
  2. Friday, 2 December 2022 21:04 PM UTC
Yes, PG seems to be very picky about having a Schema Name setting globally or as DML qualifier.

Soc .. are you all good now?
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 2 December 2022 20:14 PM UTC
  2. PowerBuilder
  3. # 2

Same for me for PB2021 ... Just a DSN name change. Works perfectly.

Comment
There are no comments made yet.
Yakov Werde Accepted Answer Pending Moderation
  1. Friday, 2 December 2022 20:10 PM UTC
  2. PowerBuilder
  3. # 3

I found this resource  https://docs.appeon.com/pb2022/installation_guide_for_pb/Installing_PowerBuilder_demo_applications_and_database.html

It's for 2021 not 2022.  Likely nothing has changed.

I'll follow instructions and see what magic happens

 

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 2 December 2022 20:10 PM UTC
  2. PowerBuilder
  3. # 4

Hi Yakov;

  This looks wrong as Appeon has never used the name "EAS Demo DB" for the PB IDE's Demo DB.

In my PB 2022, the proper name "PB Demo DB" was installed for PostGreSQL OK as follows:

 

Note: The installation should be for the ANSI PG SQL as well.

Regards ... Chris

Comment
There are no comments made yet.
Yakov Werde Accepted Answer Pending Moderation
  1. Friday, 2 December 2022 20:05 PM UTC
  2. PowerBuilder
  3. # 5

I continued with the installation and manually setup a DBProfile.   In the demo app I changed the DSN to match my chosen identifier  

 

SQLCA.DBParm = "ConnectString='DSN=EAS Demo DB'"

 

I can connect but the database has no tables

 

Where can I find the scripts to create the Demo DB schema and load the tables with sample data?

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.