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

problems connecting to postgresql with unixodbc

From: mlennert(at)ulb(dot)ac(dot)be
To: pgsql-interfaces(at)postgresql(dot)org
Subject: problems connecting to postgresql with unixodbc
Date: 2001-01-24 12:09:49
Message-ID: E14LOkH-0000d5-00@paf-linux.ulb.ac.be (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hello,

I'm running postgresql 7.0.3-4, on debian unstable, and I have trouble 
connecting to databases via odbc. I use unixodbc 2.0.3-1, and I can see
the data source in the DataManager, but when I try to connect I get the
following error:

'[unixODBC]Could not connect to the server;
Could not connect to remote socket.'

People have suggested to me that the problem might be that the
postmaster was not started with the -i option. I verified the postmaster.init 
file and
PGALLOWTCPIP=yes is set.

My pg_hba.conf file reads:

local        all                                           password
host         all         127.0.0.1     255.255.255.255     password


Can someone help me ?

Moritz


Responses

pgsql-interfaces by date

Next:From: Bruce MomjianDate: 2001-01-24 13:41:38
Subject: Re: PgAccess - small bug?
Previous:From: Kogotkov, VyacheslavDate: 2001-01-24 10:59:20
Subject: Can't connect to anonCVS !

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