Re: Status of ODBC driver managers on Unix

Okay, I've implemented and committed the following:

--with-iodbc    builds driver against iODBC's headers and -liodbcinst
--with-unixodbc    builds driver against unixODBC's headers and -lodbcinst
(neither)    what we had before
(both)        doesn't work (too complicated right now)

(The patch looks larger than the change is conceptually because I moved
some of the common #ifndef WIN32 code into psqlodbc.h so we don't have to
repeat it everywhere.)

The --with-iodbc build works cleanly, which is to be expected.

The --with-unixodbc build issues a number of warnings about "assignment
from incompatible pointer type" and "int format, long int arg", which
point out 64-bit cleanness problems (on the part of our driver).

Remaining issues:

* libpsqlodbc vs. libodbcpsql:  I followed this iODBC/unixODBC schism
  right now, but I'm not sure I like it.

* Shared library version:  The driver version shipped with unixODBC has a
  completely different version number than our driver.  Does it matter?
  What should we do?

* The code still accesses the global odbcinst.ini file directly by name in
  some places, rather than relying on the odbcinst library to find it.
  This should be fixed, but I'm not sure how in each case.  Maybe
  something for Nick to look at.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter