Thread: Re: [ADMIN] ODBC Call fail? (fwd)
---------- 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
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 > > > >
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