password crypt authentication not supported error when connecting postgreSQL and automation anywhere

Question

I am trying to connect Automation anywhere with postgreSQL For that I have created with all three below entries

Earlier, I was getting this error "test connection failed error in initializing the provider. the specified dsn contains an architecture mismatch between the driver and application postgresql" when I was trying to connect 32-bit Automation anywhere to 64bit DNS, but after created 32 bit DNS and I am getting this error "password crypt authentication not supported".

Can anyone help me resolve this?

Thanks

Answer 1

The issue you are facing is due to the old version of the driver, If you update your ODBC driver this should go away.  Any version above 8.4 should be fine however, I would recommend you to use the latest drivers.