I want to create a ADO SQL Sensor using the psqlODBC driver (PostgressQL). My connectionstring looks as follows (changed sensitive info):
Driver={PostgreSQL ANSI};Password=aBcD*+.&B;Server=10.10.1.10;Port=5432;Database=test;Uid=test_user;
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?
Add comment