1. Olan Knight
  2. PowerBuilder
  3. Thursday, 24 June 2021 19:24 PM UTC

FYI -

Summary:
   You can create multiple databases from a single PostgreSQL driver.

Details:
PowerBuilder R2019R3
PostgreSQL 12
Windows 10


These instructions assume that at least one PostgreSQL driver has been successfully installed onto the Windows 10 platform.

Open the Windows 32 bit ODBC Administrator.


Click on the SYSTEM DSN tabpage.

Click ADD.

Scroll down and select "PostgreSQL Unicode".

Click FINISH.

This opens up the baseline configuration.
 - In my case I have previously put data into the baseline DSN.
 - The first time you open this SETUP window, the fields will all be blank.

 

At this point and ONLY at this point, the Data Source field can be renamed.

Change the Data Source field/name, as well as the Description, to something unique and appropriate:

Populate all fields appropriately.

Click SAVE.

Now when you examine the set of System DSNs, the new DSN appears as a separate entity.
- Note that there are two new DSNs listed.

 

 

This new DSN can be used in the PowerBuilder ODBC database Profile:

Be sure to set up all of the tabpages in the PROFILE correctly for a PG database.

Enter the CatalogTable Owner in lower case to match the database name.






   Because of the multiple, separate DSNs, we can have multiple database PROFILES in PowerBuilder.

 

 

Sivaprakash BKR Accepted Answer Pending Moderation
  1. Tuesday, 29 June 2021 13:26 PM UTC
  2. PowerBuilder
  3. # 1

Hi Olan,

May be out of the purview of this thread !

Can you connect Postgresql, without giving IP address in the Server column ?  instead of IP address can we use the Server computer name ?  If yes, can you share how ?

Happiness Always
BKR Sivaprakash

 

Comment
  1. Olan Knight
  2. Tuesday, 29 June 2021 17:36 PM UTC
I was not able to successfully connect without the IP address. To be fair, once I got a connection technique working, I pretty much stopped looking back at the other, non-IP connection style.
  1. Helpful
  1. Sivaprakash BKR
  2. Wednesday, 30 June 2021 04:40 AM UTC
Thanks Olan,

You attached images gave me the impression that you have succeeded in connecting without IP address.
  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 24 June 2021 19:36 PM UTC
  2. PowerBuilder
  3. # 2

Hi Olan, this is good stuff!  It’s going to be a lot easier to find and benefit more people if you post this as an article rather than buried in the Q&A: https://community.appeon.com/index.php/articles-blogs/write-an-article

 

Comment
  1. Olan Knight
  2. Thursday, 24 June 2021 19:37 PM UTC
Sure, I'll do that.
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Thursday, 24 June 2021 19:39 PM UTC
Thanks!
  1. Helpful
  1. Olan Knight
  2. Thursday, 24 June 2021 19:53 PM UTC
Done! :)
  1. Helpful
There are no comments made yet.
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Thursday, 24 June 2021 19:34 PM UTC
  2. PowerBuilder
  3. # 3

Hi Olan!

Thank you so much for sharing these guides with the community! I'm sure they'll be of use to many

Regards,
Francisco

Comment
  1. Olan Knight
  2. Thursday, 24 June 2021 19:35 PM UTC
You are most welcome!

I klnow that finding out this info required major effort, so I thought I'd try to ease the pain for the next person travelling down the same road. :)
  1. Helpful
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.