Re: psqlODBC driver does not work

Bob Woodside <dumbledore(at)woodsway(dot)com> writes:
> "Yury Koles" <fresh_impression(at)hotmail(dot)com> wrote:
>> I've built ODBC driver from unixODBC distribution:
>> 'libodbcpsql.so' and connected using that one with
>> isql.

> In a word, don't. I'm not up on the history of that driver, but
> I have the impression that it's fairly obsolete. I've never gotten it to
> work properly. Someone else on the list may be able to shed some light
> on its history.

I don't know anything about its history, but recently I changed the
specfile for Red Hat's unixODBC RPM to have this package description:

: Install unixODBC if you want to access databases through ODBC. This
: package includes low-level drivers for MySQL, PostgreSQL, and local files.
: However, the included drivers are not as up-to-date as the ones distributed
: separately. It is recommended that you install and use the MyODBC package
: if you need a driver for MySQL, and/or the postgresql-odbc package for
: PostgreSQL.

libodbcpsql.so is the obsolete driver included in unixODBC. psqlodbc.so
is the one from the postgresql-odbc package.

(If anyone on the list has a comment about that description, let me
know.)

regards, tom lane