Thread: ODBC on cygwin/NT Postgres 7.1

How does one set up ODBC on a cygwin/NT/Postgres 7.1 installation? I already had
a psqlodbc.dll from the last install (7.0.3). Do I need to recompile a new one
with VC++? Do I need to recompile postgres with --with-odbc? I'm using a
precompiled 7.1 that came along with cygwin 1.1.8 and I don't know if it was
included. Any info appreciated.

LB

lbottorff@harveycounty.com wrote:
>
> How does one set up ODBC on a cygwin/NT/Postgres 7.1 installation? I already had
> a psqlodbc.dll from the last install (7.0.3). Do I need to recompile a new one
> with VC++?

You could download the binary from ftp sites.
Go to http://www.postgresql.org/ and select a FTP mirror.
You would find the latest driver
  odbc/versions/psqlodbc-07_01_0004.zip.

> Do I need to recompile postgres with --with-odbc?

No. The driver made with --with-odbc doesn't work with
M$ ODBC driver manager. It is designed to work with
iODBC driver manager. I don't know if iODBC works under
Windows. Even though iODBC works, few(no ?) applications
know iODBC under Windows.

regards,
Hiroshi Inoue