PostgesSQL ODBC Connection - FATAL: password authentication failed for user "xy"
Hi together,
currently I am configuring some new ODBC PostgreSQL Unicode (x64) connections to a PostgreSQL database.
I need to connect to different schema (plants) in the database. Always with different user and password. Host/Server are always the same. For some schema I can create a ODBC connection without any problem and for some I always get the following error:
FATAL: password authentication failed for user "xy"
The password and the user are correct, I verified that by successfully connecting with QlikView to the database via the QvOdbcConnectorPackage.
Does any of you knowing the problem or what I can do. Do I have to change the settings in the PostgreSQL ?