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

Re: Postgres 7.1, iODBC and PHP4

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Przem Kowalczyk <przem(at)engine(dot)com(dot)pl>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Postgres 7.1, iODBC and PHP4
Date: 2001-04-23 06:57:53
Message-ID: 3AE3D271.7FE0F088@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc
Przem Kowalczyk wrote:
> 
> Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> wrote in message
> news:3AE0EF18(dot)316AF9D4(at)tpf(dot)co(dot)jp(dot)(dot)(dot)
> > Przem Kowalczyk wrote:
> > >
> > > Hi.
> > >
> > > I've encountered some problems with settig up the subject configuration.
> > > It looks like php is able to connect to ODBC, but then ODBC cannot
> connect
> > > to Posgresql.
> 
> {snip}
> 
> >
> > Please use ~/.odbc.ini(user DSN) instead and
> > change the content as follows.
> >
> > ~/.odbc.ini:
> > ---start
> > ;
> > ;  odbc.ini
> > ;
> > [ODBC Data Sources]
> > wisenet=PostgreSQL
> >
> > [wisenet]
> > driver=/www/lib/libpsqlodbc.so
> > servername=localhost

Servername=localhost

> > port=5432

Port=5432

> > database=wisenet

Database=wisenet

> > username=nobody

Username=nobody

> > password=nobody

Password=nobody

> > serverType=Postgresql
> > readonly=no

ReadOnly=0

> > trace= yes
> > tracefile=/tmp/sql.log
> > DebugFile=/tmp/sqldebug.log
> > ---end
> >
> > In addtion please confirm that the postmaster was
> > started with -i option and the pg_hba.conf file
> > was set up to allow TCP/IP connection from localhost.
> 
> I did as you said, but there is no change :-(

Hmm, PostgreSQL ODBC driver seems case-sensitive.
Please change as above and try again.
Never forget to remove blanks around '='.

> I tried to use root, postgres and nobody home directories but it didn't
> help.
> I know, that /www/etc/odbc.ini has been read because if I change name of the

iODBC driver manager may read /www/etc/odbc.ini but 
the current PostgreSQL ODBC driver doesn't read it
unfortunately.

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-04-23 07:40:07
Subject: RE: Another bug with parse statements on
Previous:From: Andrea AimeDate: 2001-04-23 06:24:06
Subject: Re: Another bug with parse statements on

pgsql-general by date

Next:From: Louis-David MitterrandDate: 2001-04-23 07:06:47
Subject: Re: last comma inside "CREATE TABLE ()" statements
Previous:From: Dan WilsonDate: 2001-04-23 06:49:00
Subject: phpPgAdmin 2.3 Released [security bug fix]

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