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

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