How do you set the special characters in passwords for connections in DBSolo ?

[Zafer]

Marko,

in the database, the password was set by using

alter user zafer password 'idiL@20+19%!_\?' ;

this works in psql - when I have an entry in the .pgpass file:

mypgserver:5432:my_db:zafer:idiL@20+19%\!_\\?

(see the escape \ characters before the ! and \ )

It also works in our Java applications.

I have tried setting this same password using plain password as in the database or with the escape \ characters in DBSolo connection and both fails.

What is the requirement in DBSolo for special characters in passwords.

What would you enter in the connection password field in DBSolo for an actual user password - which is (from the above example):

idiL@20+19%!_\?

Let me know as soon as possible, given secure passwords is a requirement in our case.

thanx

Z.

[DB Solo Admin]

What is the error you're getting and does it only happen with certain characters?

Marko