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

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