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

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