That may well be the problem. Holidays are starting now, so I will be able to check it in January.
> Date: Tue, 24 Dec 2013 08:05:05 -0800
> From: adrian.klaver@gmail.com
> To: bart_klein_ikink@hotmail.com; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Database link from Postgres to Oracle using ODBC
>
> On 12/23/2013 11:59 PM, Bart Klein Ikink wrote:
> > I am a newbie so I may have done something wrong. I have made a database
> > link from Oracle 11.2 to Postgres 9.2 using unixODBC, Oracle HS and
> > psqlODBC. It is working fine.
> >
> > Now I want to do it the other way around, which is making a database
> > link from Postgres 9.2 to Oracle 11.2. I have figured out that I have to
> > install ODBC-Link 1.0.4 or Oracle_fdw 0.9.9.
> >
> > I tried to install ODBC-Link 1.0.4 and Oracle_fdw 0.9.9, but both have
> > similar problems as shown below (using ODBC-Link 1.0.4):
> >
> > [root]# export PATH=$PATH:/usr/pgsql-9.2/bin
> > [root]# pg_config --pgxs
> > /usr/pgsql-9.2/lib/pgxs/src/makefiles/pgxs.mk
> > [root]# USE_PGXS=1 make
> > gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions
> > -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic
> > -I/usr/include/et -Wall -Wmissing-prototypes -Wpointer-arith
> > -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> > -Wformat-security -fno-strict-aliasing -fwrapv -fpic -I. -I.
> > -I/usr/pgsql-9.2/include/server -I/usr/pgsql-9.2/include/internal
> > -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include
> > -c -o odbclink.o odbclink.c
> > In file included from odbclink.c:17:
> > odbclink.h:4:17: error: sql.h: No such file or directory
> > odbclink.h:5:20: error: sqlext.h: No such file or directory
>
> >
> > What is the problem here?
>
> The *.h files are supplied by unixodbc-devel, so do you have that
> installed or are the files in the PATH where they can be found?
>
> --
> Adrian Klaver
> adrian.klaver@gmail.com
>
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
