Error connecting to PostgreSQL - SCRAM authentication requires libpq version 10 or above

[alessandro_rd]

I’m making changes to a project to use PostgreSQL as the main data source instead of Denodo, aiming for greater availability and stability in RPA executions.

The error occurs when running the automation (in ODBC Data Sources and even in the Connection Wizard, authentication returns success), but in the activity that connects to the PostgreSQL database available on a company server, the connection fails. For communication, I’m using a 32-bit ODBC driver. The project is currently on the Windows-Legacy version, and even after updating UiPath.Database.Activities from v1.7.1 to v1.10.1, the error persists. The PostgreSQL ODBC driver version I’m using is 17.0.

I created a new project from scratch to test using the Windows version and a 64-bit ODBC driver. In this setup, the activity works.

I need help understanding if there’s anything that can be done in UiPath to “force” the use of libpq version 10 or above, since from what I’ve researched, the driver version already supports libpq v10.

Studio Version: 23.10.9

Important:

1. I found suggestions online to change the encryption from scram-sha-256 to md5 in the postgresql.conf and pg_hba.conf files, but PostgreSQL is installed on a server I don’t have access to modify.
2. I have 7 similar automations, each containing 15 to 20 workflows in the project. I tried migrating the project from Legacy to Windows, but many activities break. Therefore, migrating all automations to Windows is not feasible at the moment, as all other activities are working fine, and there’s no Windows-specific activity that forces me to update the project.
   
   

[MohammedShabbir (shabbir.qs)]

To TS , can you create separate windows project only for executing postGre sql queries, then you can try calling this from legacy. Give this a try.