Connect to remote database

Connect to remote database

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

Re: Connect to remote database

Postby 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/postgresql/docs/?SecureConnections.html
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44

Re: Connect to remote database

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

Re: Connect to remote database

Postby 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/postgresql/editions.html
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL