Tech Articles


Create Multiple DSNs from a single PostgreSQL Driver


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.

 

Comments (0)
There are no comments posted here yet

Find Articles by Tag

CoderObject Source Code OLE Syntax Class RibbonBar Repository RibbonBar Builder Database Profile Resize PowerBuilder (Appeon) .NET Assembly Graph .NET DataStore SOAP UI Modernization PowerBuilder Web Service Proxy API InfoMaker Text NativePDF 64-bit DragDrop Icon XML Messagging Authorization ActiveX Application SqlExecutor DataType OrcaScript Database Configuration Bug Database Object Azure Debugger C# Expression PowerServer Mobile SQL 32-bit Excel Transaction OAuth 2.0 SnapObjects PostgreSQL Import PDFlib DevOps .NET Std Framework Import JSON Menu Stored Procedure SqlModelMapper COM Window Model GhostScript Git Installation PowerScript (PS) DLL WinAPI Event Handling CI/CD Design Debug External Functions TortoiseGit TLS/SSL Windows OS TFS PowerServer Web REST Platform WebBrowser Performance BLOB MessageBox Error SnapDevelop Database Table Data PostgreSQL ODBC driver JSON Debugging Database Table Schema DataWindow JSON CrypterObject Export RichTextEdit Control PowerBuilder Compiler Array Interface DataWindow TreeView Data Sort Database Connection RESTClient Script Encryption Database Table Trial Variable Filter Mobile Testing Deployment Service Oracle Database Painter SDK Web API Migration License Validation Event Export JSON Authentication Source Control Outlook JSONGenerator IDE Elevate Conference UI Themes JSONParser Charts SVN PBDOM Automated Testing Linux OS Jenkins ODBC Branch & Merge Windows 10 Icons PFC SQL Server HTTPClient PDF Android Encoding UI OAuth Event Handler File iOS Open Source