Re: psqlODBC driver does not work

Bob Woodside <dumbledore@xxxxxxxxxxxx> writes:
> "Yury Koles" <fresh_impression@xxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend