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