Connect to remote database

[Blasius93]

Hi,
I have a big problem and i tried to fix it, but I don;t know how...
I tried to connect with remote database PostgreSQL using VisualStudio2013 and dotConnect.
I have host, userID, pass, database name and direction that SSL must be on/true.

When I use PostgreSQL Connection by dotConnect, i've got this message:
"no pg_hba.conf entry for host" (ip, user, database) "SSL off".
I don't see options SSL ON/TRUE.

Maybe someone help me? I really try fix it, so please for quick help.

P.S. With PGAdmin there is no problem with connect.

[Pinturiccio]

dotConnect for PostgreSQL allows connecting via SSL. For this you need to specify "Ssl Mode=Require" in the connection string. SSL connection also can be configured via connection properties. For more information, please refer to http://www.devart.com/dotconnect/postgr ... tions.html

[Blasius93]

For this you need to specify "Ssl Mode=Require"

Yes, I know, but i can't change connecting strin in properties in... hard way.

SSL connection also can be configured via connection properties

But where/how? Maybe I'm blind... but i don't see this option.
Can you show me where it is? http://postimg.org/image/ij1cig1m9/

I saw that website before, but there is no informations about connecting using properties.

[Pinturiccio]

According to your screenshot, you use the Express edition of dotConnect for PostgreSQL. SSL is supported in all editions of dotConnect for PostgreSQL except the Express edition. For more information, please refer to http://www.devart.com/dotconnect/postgr ... tions.html