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
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 |