Re: help compiling psqldobc-08.03.0400

This is a multi-part message in MIME format.

------_=_NextPart_001_01CA00C8.7426BCC9
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Anyone have any ideas on this? I've been playing around with some
different odbc and psqlodbc combinations with no luck so far.

=20

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.

=20

Thanks!

=20

From: Kulik, Scott=20
Sent: Wednesday, June 24, 2009 3:34 PM
To: 'pgsql-odbc@postgresql.org'
Subject: help compiling psqldobc-08.03.0400

=20

Hi,

=20

Here are my specs:

=20

Redhat Enterprise Linux AS4

=20

unixODBC-2.2.14 (compiled from source)

psqlodbc-08.03.0400 (attempting to compile from source)

=20

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

=20

....

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=3DCC --mode=3Dcompile 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

=20

Thanks

Scott K


------_=_NextPart_001_01CA00C8.7426BCC9
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/mee tings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/x ml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/di rectory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/20 02/1/alerts/"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/partto part" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/wor kflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsi g-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsi g" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/200 6/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compa tibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/2006/types"=
=
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor talServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"
" xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

Re: 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.
*/

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: help compiling psqldobc-08.03.0400

I have installed unixODBC in /usr/local so I export then following:

export LD_LIBRARY_PATH=3D/usr/local/lib
export LDFLAGS=3D-L/usr/local/lib
export CPPFLAGS=3D-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]=20
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.
*/

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc