Re: Postgres 7.1, iODBC and PHP4

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