RE: ODBC include files - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject RE: ODBC include files
Date
Msg-id EKEJJICOHDIEMGPNIFIJAEIDFDAA.Inoue@tpf.co.jp
Whole thread Raw
In response to Re: ODBC include files  (Peter Eisentraut <peter_e@gmx.net>)
Responses RE: ODBC include files  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-odbc
> -----Original Message-----
> From: Peter Eisentraut [mailto:peter_e@gmx.net]
>
> Hiroshi Inoue writes:
>
> > > I also see that our isqlext.h includes isql.h without an iodbc/ path
> > > prefix, which seems incorrect.
> >
> > Sorry where's iodbc/ ?
>
> If you install the odbc driver from the source distribution then the said
> headers are installed into /usr/local/pgsql/include/iodbc/*.h.

Oh I see.  Hmm for what are these files installed ? Direct call for
psqlodbc driver ?  Is it really needed ?

> So if you
> blindly do -I/usr/local/pgsql/include and #include "iodbc/isqlext.h" you
> won't find isql.h (or worse, the wrong one).  I think this is the remnant
> of an improper import of the odbc driver into out our source tree way back
> when.
>
> > > Is there something that might need updating here?  If I were
> to write an
> > > ODBC application, which package's files should I include?
> >
> > IMHO you should include iodbc package's files.
>
> Perhaps we should not install ours at all in that case?

Yes I think so.  Driver manager isn't only for PostgreSQL.

> The iodbc ones
> seem better maintained and you need to have iodbc anyway.

I'm happy if someone(you ?) maintains psqlodbc on unix.
I got few replies from PG community about psqlodbc on unix.
I've been wondering how many people are using psqlodbc
driver on unix in reality. Switching to unixODBC is worth
considering as an alternative.

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: Kristis Makris
Date:
Subject: Re: Error messages not always reported through the ODBC driver -STATEMENT ERROR missing
Next
From: Peter Eisentraut
Date:
Subject: RE: ODBC include files