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

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