remote connection problem

From: "Ilija Vidoevski" <ilija(at)fructal(dot)com(dot)mk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: remote connection problem
Date: 2012-05-16 11:43:19
Message-ID: 32F0B952C0CD40B480719F3326DD3B11@fructal.com.mk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I can not access to postgresql server 9.1.3 form client computer with
front-end application written in MS Visual Foxpro 9 SP2.

Application made connection when work on PC where is postgresql server
installed.

Connstr="DRIVER={PostgreSQL odbc
driver(unicode)};server=localhost;Port=5432;Database=mydatabase;
Uid=postgres;Pwd=mypwd;UseServerSidePrepare=1;MaxVarcharSize=254;UnknownsAsL
ongVarchar=0;TextAsLongVarchar=0;"

I installed ODBC driver v 09.00.0310-1 on client PC. Also firewall is
disabled on server side.

This a settings in postgresql.conf file:

listen_addresses = '*'

This a settings in pg_hba.conf file:

# IPv4 local connections:

host all all 0.0.0.0/0 md5

# IPv6 local connections:

host all all ::0/0 md5

I got this message:

Connectivity error: Could not connect to server;

No connection could be made because the target machine actively refused it
(127.0.0.1:5432)

Any ideas what is wrong ?.

Thank's

Ilija

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2012-05-16 13:04:18 Re: Console Output
Previous Message Francisco Leovey 2012-05-15 17:51:56 Re: How to select by proximity