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

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