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.
Connect to remote database
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Connect to remote database
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
Re: Connect to remote database
Yes, I know, but i can't change connecting strin in properties in... hard way.For this you need to specify "Ssl Mode=Require"
But where/how? Maybe I'm blind... but i don't see this option.SSL connection also can be configured via connection properties
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.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Connect to remote database
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