Database link from Postgres to Oracle using ODBC

From: Bart Klein Ikink <bart_klein_ikink(at)hotmail(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Database link from Postgres to Oracle using ODBC
Date: 2013-12-24 07:59:43
Message-ID: DUB117-W51E431DFD596F52C6857FDC1C00@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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
In file included from odbclink.c:17:
odbclink.h:11: error: expected specifier-qualifier-list before âSQLHENVâ
odbclink.h:17: error: expected specifier-qualifier-list before âSQLHSTMTâ
odbclink.c: In function â_PG_finiâ:
odbclink.c:106: warning: implicit declaration of function âSQLDisconnectâ
odbclink.c:106: error: âodbcconnâ has no member named âhConâ
odbclink.c:107: warning: implicit declaration of function âSQLFreeConnectâ
odbclink.c:107: error: âodbcconnâ has no member named âhConâ
odbclink.c:108: warning: implicit declaration of function âSQLFreeEnvâ
odbclink.c:108: error: âodbcconnâ has no member named âhEnvâ
....

many more lines

What is the problem here?

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Saito 2013-12-24 12:58:28 Re: about psqlODBC project page
Previous Message Heikki Linnakangas 2013-12-22 20:56:22 Re: about psqlODBC project page