Connect to remote database

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Blasius93
Posts: 2
Joined: Wed 25 Jun 2014 16:10

Connect to remote database

Post by Blasius93 » Wed 25 Jun 2014 16:17

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
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Connect to remote database

Post by Pinturiccio » Thu 26 Jun 2014 12:07

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
Posts: 2
Joined: Wed 25 Jun 2014 16:10

Re: Connect to remote database

Post by Blasius93 » Thu 26 Jun 2014 15:21

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
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Connect to remote database

Post by Pinturiccio » Fri 27 Jun 2014 15:12

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

Post Reply