Thread: Re: help compiling psqldobc-08.03.0400
Anyone have any ideas on this? I’ve been playing around with some different odbc and psqlodbc combinations with no luck so far.
I have tried all 8.0 versions of psqlodbc but they all get the same errors running make as mentioned below. I was able to successfully compile the latest version 7 but am having issues created a database link from oracle 10g with this version so I’m trying to get the latest 8.0 working.
Thanks!
From: Kulik, Scott
Sent: Wednesday, June 24, 2009 3:34 PM
To: 'pgsql-odbc@postgresql.org'
Subject: help compiling psqldobc-08.03.0400
Hi,
Here are my specs:
Redhat Enterprise Linux AS4
unixODBC-2.2.14 (compiled from source)
psqlodbc-08.03.0400 (attempting to compile from source)
my postgresql rpm’s:
[root@soo-srv-db4 psqlodbc-08.03.0400]# rpm -qa | grep postgres
postgresql-8.3.7-1PGDG.rhel4
postgresql-libs-8.3.7-1PGDG.rhel4
postgresql-devel-8.3.7-1PGDG.rhel4
…
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/include -Wall -g -O2 -MT multibyte.lo -MD -MP -MF .deps/multibyte.Tpo -c multibyte.c -fPIC -DPIC -o .libs/multibyte.o
if /bin/sh ./libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/include -Wall -g -O2 -MT odbcapi.lo -MD -MP -MF ".deps/odbcapi.Tpo" -c -o odbcapi.lo odbcapi.c; \
then mv -f ".deps/odbcapi.Tpo" ".deps/odbcapi.Plo"; else rm -f ".deps/odbcapi.Tpo"; exit 1; fi
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/include -Wall -g -O2 -MT odbcapi.lo -MD -MP -MF .deps/odbcapi.Tpo -c odbcapi.c -fPIC -DPIC -o .libs/odbcapi.o
odbcapi.c:1115: error: syntax error before "SQLROWSETSIZE"
odbcapi.c: In function `SQLExtendedFetch':
odbcapi.c:1120: error: number of arguments doesn't match prototype
/usr/local/include/sqlext.h:1862: error: prototype declaration
odbcapi.c:1122: error: `hstmt' undeclared (first use in this function)
odbcapi.c:1122: error: (Each undeclared identifier is reported only once
odbcapi.c:1122: error: for each function it appears in.)
odbcapi.c:1132: error: `fFetchType' undeclared (first use in this function)
odbcapi.c:1132: error: `irow' undeclared (first use in this function)
odbcapi.c:1132: error: `rgfRowStatus' undeclared (first use in this function)
odbcapi.c:1133: error: `pcrow' undeclared (first use in this function)
make[1]: *** [odbcapi.lo] Error 1
make[1]: Leaving directory `/root/psqlodbc-08.03.0400'
make: *** [all] Error 2
Thanks
Scott K
,--- You/Scott (Thu, 9 Jul 2009 15:07:07 -0400) ----* | Here are my specs: | | unixODBC-2.2.14 (compiled from source) | psqlodbc-08.03.0400 (attempting to compile from source) Most important: what options do you call `configure' with when you are trying to build PostgreSQL ODBC driver? Most important in that: are you using --with-unixodbc? -- Alex -- alex-goncharov@comcast.net -- /* * Never let someone who says it cannot be done * interrupt the person who is doing it. */
I have installed unixODBC in /usr/local so I export then following: export LD_LIBRARY_PATH=/usr/local/lib export LDFLAGS=-L/usr/local/lib export CPPFLAGS=-I/usr/local/include I am not using any other configure options. I have tried --with-unixodbc but I still get the same error message. -----Original Message----- From: Alex Goncharov [mailto:alex-goncharov@comcast.net] Sent: Thursday, July 09, 2009 3:42 PM To: Kulik, Scott Cc: pgsql-odbc@postgresql.org Subject: Re: [ODBC] help compiling psqldobc-08.03.0400 ,--- You/Scott (Thu, 9 Jul 2009 15:07:07 -0400) ----* | Here are my specs: | | unixODBC-2.2.14 (compiled from source) | psqlodbc-08.03.0400 (attempting to compile from source) Most important: what options do you call `configure' with when you are trying to build PostgreSQL ODBC driver? Most important in that: are you using --with-unixodbc? -- Alex -- alex-goncharov@comcast.net -- /* * Never let someone who says it cannot be done * interrupt the person who is doing it. */