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

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