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

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