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

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