Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org
	(8.8.8/8.7.5) with ESMTP id PAA27272 for
	<pgsql-admin@postgreSQL.org>; Mon, 1 Jun 1998 15:03:41 -0400 (EDT)
Received: from insightdist.com (nobody@localhost)
	by u1.abs.net (8.9.0/8.9.0) with UUCP id OAA16673
	for pgsql-admin@postgreSQL.org; Mon, 1 Jun 1998 14:47:11 -0400 (EDT)
X-Authentication-Warning: u1.abs.net: nobody set sender to
	insightdist.com!daveh using -f
Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03)
	id AA31289; Mon, 1 Jun 1998 14:34:56 -0400
Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA54192; Mon, 1 Jun 1998 14:34:56 -0400
Message-Id: <3572F3C6.611C0D67@insightdist.com>
Date: Mon, 01 Jun 1998 14:32:38 -0400
From: David Hartwig <daveh@insightdist.com>
Organization: Insight Distribution Systems
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Mime-Version: 1.0
To: Peter Mount <pgsqladmin@retep.org.uk>
Cc: pgsql-admin@postgreSQL.org,
	pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [ADMIN] ODBC Call fail? (fwd)
References: <Pine.LNX.3.95.980601183550.15203A-100000@retep.org.uk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Here is a check list.

ODBC Driver Data Source Checks
        1.Valid and resolvable hostname.
        2.Valid port number.  (default is 5432)
        3.Valid and existing database name.
        4.Valid user name.
        5.Valid password for the specified user.  (Required iff pg_hba.config is set
to password authenticate your client.)
PostgreSQL Server Checks
        1.Postmaster must be running.
        2.Postmaster must run with the -i option to allow remote connections.
        3.The pg_hba.conf file in $PGPATH/data directory must be configured to allow
your remote host to connect.

The following line pg_hba.conf  will allow all external systems pasworded access to
your all databases.

host         all         0.0.0.0       0.0.0.0           password

You may want to mask the IP.

I assume your version of the driver is something greater than.    6.30.0036

Peter Mount wrote:

> ---------- Forwarded message ----------
> Date: Sun, 31 May 1998 18:52:53 +0530
> From: Venugopal <venu@gtsl.co.in>
> To: Peter Mount <pgsqladmin@retep.org.uk>
> Subject: Re: [ADMIN] ODBC Call fail?
> Newsgroups: comp.databases.postgresql.admin
>
> Peter Mount wrote:
>
> > On Sat, 30 May 1998, Thomas Lester wrote:
> >
> > > Everytime I try to hit my database from my ODBC driver I get ODBC call failed.
> > > I have a pretty good idea why.  I do not have an entry for postgres in my
> > > /etc/services (I'm using solaris 2.6).  Am I correct?
> >
> > You don't need an entry.
> >
> > Are you running the postmaster with the -i argument which enables TCP/IP
> > communication?
> >
> >
>
> Hi, I am facing the same problem even though i run postmaster with "-i"  and -p
> 5432 option.
> psql connects over the loopback but,
> psql -d mydb -h 192.168.0.34 -p 5432 - fails to connect. (192.168.0.34 is my IP)
>
> I rectified this by editing the /var/lib/pgsql/pg_hba.conf to add
>
> host         all        192.168.0.0    255.255.255.0     trust
>
> at the end of the file....
> I know this is not ideal, with no security, but then , i can connect using ip...
> But i am still not able to connect thru ODBC on Win95... any solutions ?
>
> venu