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

> 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)

Hiroshi Inoue wrote:
>
> 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.

I did a quick scan of the PostgreSQL ChangeLog before starting the patch,
but must've missed that. It certainly sounds like a good idea.

But it also seems like a good idea for libpsqlodbc to check sensible
locations even when used with an earlier version of iODBC (or some other
driver manager).

Regards,
Ross Thomas