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.
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 [at] 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 [at] 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=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
Thanks
Scott K
------_=_NextPart_001_01CA00C8.7426BCC9
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
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">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
[at] font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
..MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>Anyone have any ideas =
on this?
I’ve been playing around with some different odbc and psqlodbc
combinations with no luck so far.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span style=3D'color:#1F497D'>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.<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>Thanks!<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0in 0in 0in'>
<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' >From:</span>=
</b><span
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' > Kulik, =
Scott <br>
<b>Sent:</b> Wednesday, June 24, 2009 3:34 PM<br>
<b>To:</b> 'pgsql-odbc [at] postgresql.org'<br>
<b>Subject:</b> help compiling psqldobc-08.03.0400<o:p></o:p></span></p>
</div>
</div>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Hi,<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal> Here are my specs:<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Redhat Enterprise Linux AS4<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>unixODBC-2.2.14 (compiled from =
source)<o:p></o:p></p>
<p class=3DMsoNormal>psqlodbc-08.03.0400 (attempting to compile from =
source)<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>my postgresql rpm’s:<o:p></o:p></p>
<p class=3DMsoNormal>[root [at] soo-srv-db4 psqlodbc-08.03.0400]# rpm -qa | =
grep
postgres<o:p></o:p></p>
<p class=3DMsoNormal>postgresql-8.3.7-1PGDG.rhel4<o:p></o:p></p>
<p class=3DMsoNormal>postgresql-libs-8.3.7-1PGDG.rhel4<o:p></o:p></p>
<p class=3DMsoNormal>postgresql-devel-8.3.7-1PGDG.rhel4<o:p></o:p></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
style=3D'color:#1F497D'>…<o:p></o:p></span></p>
<p class=3DMsoNormal>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<o:p></o:p></p>
<p class=3DMsoNormal>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; =
\<o:p></o:p></p>
<p class=3DMsoNormal>then mv -f ".deps/odbcapi.Tpo"
".deps/odbcapi.Plo"; else rm -f ".deps/odbcapi.Tpo"; =
exit
1; fi<o:p></o:p></p>
<p class=3DMsoNormal> 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<o:p></o:p></p>
<p class=3DMsoNormal>odbcapi.c:1115: error: syntax error before
"SQLROWSETSIZE"<o:p></o:p></p>
<p class=3DMsoNormal>odbcapi.c: In function =
`SQLExtendedFetch':<o:p></o:p></p>
<p class=3DMsoNormal>odbcapi.c:1120: error: number of arguments doesn't =
match
prototype<o:p></o:p></p>
<p class=3DMsoNormal>/usr/local/include/sqlext.h:1862: error: prototype
declaration<o:p></o:p></p>
<p class=3DMsoNormal>odbcapi.c:1122: error: `hstmt' undeclared (first =
use in this
function)<o:p></o:p></p>
<p class=3DMsoNormal>odbcapi.c:1122: error: (Each undeclared identifier =
is
reported only once<o:p></o:p></p>
<p class=3DMsoNormal>odbcapi.c:1122: error: for each function it appears =
in.)<o:p></o:p></p>
<p class=3DMsoNormal>odbcapi.c:1132: error: `fFetchType' undeclared =
(first use in
this function)<o:p></o:p></p>
<p class=3DMsoNormal>odbcapi.c:1132: error: `irow' undeclared (first use =
in this
function)<o:p></o:p></p>
<p class=3DMsoNormal>odbcapi.c:1132: error: `rgfRowStatus' undeclared =
(first use
in this function)<o:p></o:p></p>
<p class=3DMsoNormal>odbcapi.c:1133: error: `pcrow' undeclared (first =
use in this
function)<o:p></o:p></p>
<p class=3DMsoNormal>make[1]: *** [odbcapi.lo] Error 1<o:p></o:p></p>
<p class=3DMsoNormal>make[1]: Leaving directory =
`/root/psqlodbc-08.03.0400'<o:p></o:p></p>
<p class=3DMsoNormal>make: *** [all] Error 2<o:p></o:p></p>
<p class=3DMsoNormal><o:p> </o:p></p>
<p class=3DMsoNormal>Thanks<o:p></o:p></p>
<p class=3DMsoNormal>Scott K<o:p></o:p></p>
</div>
</body>
</html>
------_=_NextPart_001_01CA00C8.7426BCC9--
