Re: Database link from Postgres to Oracle using ODBC

On 01/06/2014 11:50 PM, Bart Klein Ikink wrote:
> This is what I did:
> - yum install gcc
> - yum install postgresql92-devel-9.2.5
> - extract unixODBC-2.3.2.tar.gz (in /root/test)
> - extract ODBC-Link-1.0.4.tar.gz (in /root/test)
> - cd /root/test/unixODBC-2.3.2
> - ./configure
> - make
> - make install
> - cd ..
> - cd ODBC-Link-1.0.4
> - export PATH=$PATH:/root/test/unixODBC-2.3.2/include:/usr/pgsql-9.2/bin
> - make USE_PGXS=1
>

I am not sure what is going on. I can compile here. In my case I am
using my distributions(OpenSUSE 12.2) package versions of unixODBC and
unixODBC-devel

You might try to do the same. Note it is important that they be the same
version for the same version of unixODBC. Then you could get rid of the
export path=..

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com