Connection to postgres 9.6 fails with TD 6.3.9 but works with SQLTalk

[Johann]

Hello,

I face a strange problem with TD 6.3.9 on Postgres 9.6, connecting with SQLTalk (from TD 6.3.9) no problem, I can connect, create tables, constraints, select, insert, update, delete... works normally without any issue, but when trying to connect with the td 6.3.9 application I get the following error

PostgreSQL error: Fatal: role "username" does not exist

but actually the role exist, and I can use it normal with SQLTalk.

The odbc driver for Postgres is V. 13.02.00.00 PostgreSQL ANSI. I tried also the PostgreSQL UNICODE, but no change, SQLTalk works, TD gets the above error.

Any hint is very appreciated.
With best Regards
Johann

[Harald]

Hello Johann,

did you try to change username and password to uppercase and lowercase on server and client?

Kind regards
Harald

[Johann]

Hello Harald,

yesssss this was it..... THX

Regrds
Johann