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

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