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

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