Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group