Re: Patch for ODBC driver (look for odbc.ini in more than one

Ross Thomas wrote:
>
> Since most ODBC drivers and driver managers look for odbc.ini in several
> locations on UNIX systems, it would seem sensible to have the PostgreSQL
> driver do the same thing. (This idea occurred to me after five hours of
> trying to figure out what libpsqlodbc didn't like about my /etc/odbc.ini,
> but that's another story.)
>
> iODBC, for example, does the following:
>
> 1) Checks $ODBCINI
> 2) Checks $HOME/.odbc.ini
> 3) Checks ~/.odbc.ini (where ~ is obtained from struct passwd)
> 4) Checks system-wide odbc.ini (in /etc by default)

IIRC iODBC 3.0.5 has iodbcinst library which knows
where to write/get the profile values.
PostgreSQL 7.2 provides a configure option --with-iodbc
with which PostgreSQL doesn't use gpps.c at all but links
with the installed odbcinst library.

regards,
Hiroshi Inoue