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

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