Re: Database link from Postgres to Oracle using ODBC - Mailing list pgsql-odbc
| From | Bart Klein Ikink |
|---|---|
| Subject | Re: Database link from Postgres to Oracle using ODBC |
| Date | |
| Msg-id | DUB117-W289AB9B4908F97A598CB86C1B70@phx.gbl Whole thread Raw |
| In response to | Re: Database link from Postgres to Oracle using ODBC (Adrian Klaver <adrian.klaver@gmail.com>) |
| Responses |
Re: Database link from Postgres to Oracle using ODBC
(Adrian Klaver <adrian.klaver@gmail.com>)
|
| List | pgsql-odbc |
I have included the path, but still having problems. What is wrong here?
ls -al /root/test/unixODBC-2.3.2/include/sql*
-rw-rw-r-- 1 1000 1000 82644 Apr 15 2013 /root/test/unixODBC-2.3.2/include/sqlext.h
-rw-rw-r-- 1 1000 1000 32305 Apr 15 2013 /root/test/unixODBC-2.3.2/include/sql.h
-rw-rw-r-- 1 1000 1000 11140 Apr 15 2013 /root/test/unixODBC-2.3.2/include/sqltypes.h
-rw-rw-r-- 1 1000 1000 21666 Apr 15 2013 /root/test/unixODBC-2.3.2/include/sqlucode.h
export PATH=$PATH:/root/test/unixODBC-2.3.2/include:/usr/pgsql-9.2/bin
make USE_PGXS=1
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
odbclink.c: In function âget_dataâ:
odbclink.c:746: error: âtimestamp_inâ undeclared (first use in this function)
odbclink.c:746: error: (Each undeclared identifier is reported only once
odbclink.c:746: error: for each function it appears in.)
odbclink.c:749: error: âtimestamptz_inâ undeclared (first use in this function)
make: *** [odbclink.o] Error 1
ls -al /root/test/unixODBC-2.3.2/include/sql*
-rw-rw-r-- 1 1000 1000 82644 Apr 15 2013 /root/test/unixODBC-2.3.2/include/sqlext.h
-rw-rw-r-- 1 1000 1000 32305 Apr 15 2013 /root/test/unixODBC-2.3.2/include/sql.h
-rw-rw-r-- 1 1000 1000 11140 Apr 15 2013 /root/test/unixODBC-2.3.2/include/sqltypes.h
-rw-rw-r-- 1 1000 1000 21666 Apr 15 2013 /root/test/unixODBC-2.3.2/include/sqlucode.h
export PATH=$PATH:/root/test/unixODBC-2.3.2/include:/usr/pgsql-9.2/bin
make USE_PGXS=1
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
odbclink.c: In function âget_dataâ:
odbclink.c:746: error: âtimestamp_inâ undeclared (first use in this function)
odbclink.c:746: error: (Each undeclared identifier is reported only once
odbclink.c:746: error: for each function it appears in.)
odbclink.c:749: error: âtimestamptz_inâ undeclared (first use in this function)
make: *** [odbclink.o] Error 1
> 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
> 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
pgsql-odbc by date: