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

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