PostgresSQL connect string

thank you for you site. however, I try the ODBC connect string. I got this
error:


FATAL: no pg_hba.conf entry for host "192.168.0.5", user "postgres",
database "test", SSL off

thanks for your help

--
FishingGuy RemoveThis @discussions.microsoft


"Ralph" wrote:

>
> "John S" <JohnS RemoveThis @discussions.microsoft.com> wrote in message
> news:F80720FC-21BF-44A5-B3F8-631F9DEF2C72@microsoft.com...
> > Hi
> >
> > does any one out there know how to build the Postgres SQL connect string
> for
> > ADO connection?
> >
> > thanks any one who can help.
> >
>
> http://www.connectionstrings.com/default.aspx?carrier=postgresql
>
> Google is your friend.
>
> -ralph
>
>
>
 >> Stay informed about: PostgresSQL connect string 

Hi Fishing Guy,

This reply assumes you know the location of the pg_hba.conf file.

You can change the pg_hba.conf entries for host connection to your subnet
network, such as your IP addres is 192.168.1.100, then the IP address field
in the pg_hba.conf for host IPv4 connection should be entered to
192.168.1.0/24. The 24 means for the first 24 bit stands for your subnet
network, that is your 192.168.1, then restart your postgresql services.

If it still fails, check the method of it's connection, if it's ident
sameuser, change it to md5 for an easier connection from your application
without having to had the same username logged in, then restart your
postgresql connection.

If it still fails, check for your postgresql.conf file, search for
#listen_addresses='localhost'; (or similar), if there is a "#" in front of
it, delete it to uncomment it. Then change the 'localhost' for the allowed IP
to connect to your postgresql server separated with comma, or if you'd like
an "easier" way (not recommended for production server), change the
'localhost' to '*' to allow all connection to you postgresql server.

Hope it helps you.


-- hendra.uzia --

"Fishing Guy" wrote:

> thank you for you site. however, I try the ODBC connect string. I got this
> error:
>
>
> FATAL: no pg_hba.conf entry for host "192.168.0.5", user "postgres",
> database "test", SSL off
>
> thanks for your help
>
> --
> FishingGuy.DeleteThis@discussions.microsoft
>
>
> "Ralph" wrote:
>
> >
> > "John S" <JohnS.DeleteThis@discussions.microsoft.com> wrote in message
> > news:F80720FC-21BF-44A5-B3F8-631F9DEF2C72@microsoft.com...
> > > Hi
> > >
> > > does any one out there know how to build the Postgres SQL connect string
> > for
> > > ADO connection?
> > >
> > > thanks any one who can help.
> > >
> >
> > http://www.connectionstrings.com/default.aspx?carrier=postgresql
> >
> > Google is your friend.
> >
> > -ralph
> >
> >
> >
 >> Stay informed about: PostgresSQL connect string