Your connection string will work as long as there is a DNS entry for
PGServer.

Your pg_hba.conf will however need to have an IP address/netmask. So if you
are connecting from within your local network, you can put something like:

hostssl     all      all      192.168.0.0/16       md5

Hth?


On Wed, 30 Jun 2021 at 15:54, sivapostg...@yahoo.com <sivapostg...@yahoo.com>
wrote:

> Hello,
>
> Using PostgreSQL 11
>
> Currently connecting PostgreSQL database from our Powerbuilder application
> using the IPAddress as Server Name through ODBC driver.  Would like to know
> whether we can connect naming the computername instead of IP Address ?  If
> yes, what info to be entered in pg_hba.config file ?
>
> My connection string is :
> "ConnectString='Driver=PostgreSQL
> Unicode;Database=dbname;Server=192.168.1.21;Port=5432;UID=user;PWD=pass;',DisableBind=1"
>
> Here Server is assigned with IP Address of the computer where PostgreSQL
> is installed.
> I think of doing it with
> "ConnectString='Driver=PostgreSQL Unicode;Database=dbname;Server=
> *PGServer*;Port=5432;UID=user;PWD=pass;',DisableBind=1"
>
> Is it possible ?
>
> Happiness Always
> BKR Sivaprakash
>
> --
-- 

Sent from my iPhone.

Reply via email to