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

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