Thread: Re: [ADMIN] ODBC Call fail? (fwd)

Re: [ADMIN] ODBC Call fail? (fwd)

From
Peter Mount
Date:
---------- 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



Re: [ADMIN] ODBC Call fail? (fwd)

From
Thomas Lester
Date:
That worked for me...  I made the change in my hba file for the host that
needs to connect and it works.  I wish I had enough experience in that
matter to help you out, but I don't...

Good luck,
Thomas


==============================================================
|    tlester@iakom.com  |                     Thomas Lester  |
| http://www.iakom.com  |              System Administrator  |
|                       |                             Iakom  |
==============================================================

On Mon, 1 Jun 1998, 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
>
>
>
>


Re: [ADMIN] ODBC Call fail? (fwd)

From
David Hartwig
Date:
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