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

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