I want to create a ADO SQL Sensor using the psqlODBC driver (PostgressQL). My connectionstring looks as follows (changed sensitive info):
It looks ok but the user can not authenticate. I have tested with other SQL tools on same machine with no issues. I believe it is caused but the special characters in the password. I have tried & to escape but no result. I have tried single and double quotes around the password but that doesn't work.
Any ideas how to solve this issue?