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

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