help compiling psqldobc-08.03.0400

Has anyone had any success compiling psqlodbc on Redhat Linux (I'm using
RHEL AS4). I have pretty much tried compiling with with every
combination of odbc and postgres versions but never had any luck.

I've been trying to figure this out for a few weeks but I think we may
just have to end up paying the $500/server for the openlink
driver/support.

Anyone have any suggestions that might save us a few thousand dollars?

The rest of my information is below. Let me know if there is anything
else I missed.

Thanks
Scott K.

-----Original Message-----
From: Kulik, Scott
Sent: Thursday, July 09, 2009 4:44 PM
To: pgsql-odbc [at] postgresql.org
Subject: RE: [ODBC] 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 [at] comcast.net]
Sent: Thursday, July 09, 2009 3:42 PM
To: Kulik, Scott
Cc: pgsql-odbc [at] 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 [at] 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

SKulik [ Mo, 13 Juli 2009 21:29 ] [ ID #2008611 ]

Re: help compiling psqldobc-08.03.0400

This is a multipart message in MIME format.

------=_NextPart_000_0099_01CA040B.28367790
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

hmm...looks like my original response didn't show up so i'm resending this.

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.

Scott K.

On 2009-07-09 19:42, Alex Goncharov wrote:
> ,--- 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 [at] ??? --
>
> /*
> * Never let someone who says it cannot be done
> * interrupt the person who is doing it.
> */
>
>

Author: Kulik, Scott
Date: 2009-07-09 15:072009-07-09 19:07 -400UTC
To: pgsql-odbc
Subject: Re: [ODBC] 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 [at] ???'
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=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

------=_NextPart_000_0099_01CA040B.28367790
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:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

hmm...looks
like my original response didn't show up so i'm resending =
this.<o:p></o:p>

<o:p> </o:p><=
/p>

I have
installed unixODBC in /usr/local so I export then =
following:<o:p></o:p>

<o:p> </o:p><=
/p>

export
LD_LIBRARY_PATH=3D/usr/local/lib<o:p></o:p>

export
LDFLAGS=3D-L/usr/local/lib<o:p></o:p>

export
CPPFLAGS=3D-I/usr/local/include<o:p></o:p>

<o:p> </o:p><=
/p>

I am not
using any other configure options. I have tried --with-unixodbc =
but I still
get the same error message.<o:p></o:p>

<o:p> </o:p><=
/p>

Scott =
K.<o:p></o:p>

On 2009-07-09 =
19:42, Alex
Goncharov wrote: 
> ,--- 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 [at] ??? -- 
> 
> /* 
> * Never =
let someone
who says it cannot be done 
> * =
interrupt the
person who is doing it. 
> */ =
 
> 
> =
<o:p></o:p>

Author: Kulik, Scott 
Date: 2009-07-09 15:072009-07-09 19:07 -400UTC 
To: pgsql-odbc 
Subject: Re: [ODBC] help compiling =
psqldobc-08.03.0400<o:p></o:p>

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] ???' 
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 <o:p></o:p>

<o:p> </o:p>

</div>

</body>

</html>

------=_NextPart_000_0099_01CA040B.28367790--

Scott Kulik [ Di, 14 Juli 2009 04:42 ] [ ID #2008613 ]

Re: help compiling psqldobc-08.03.0400

Scott Kulik wrote:
> Has anyone had any success compiling psqlodbc on Redhat Linux (I'm using
> RHEL AS4). I have pretty much tried compiling with with every
> combination of odbc and postgres versions but never had any luck.
>
> I've been trying to figure this out for a few weeks but I think we may
> just have to end up paying the $500/server for the openlink
> driver/support.
>
> Anyone have any suggestions that might save us a few thousand dollars?

I never had any problems with it.
This is my log of a session where I installed 08.02.0500 on a 32-bit RHEL4 =
machine:

Prerequisites:
(The first two packages are our own RPMs for PostgreSQL, you can use the
standard "libs" and "devel" packages)

# rpm -U adv-postgres-8.2.5-libs-1-1.i386.rpm
# rpm -U adv-postgres-8.2.5-devel-1-1.i386.rpm
# yum install unixODBC unixODBC-devel

Unpack and compile the software:
(Our packages install PostgreSQL into /magwien/postgres-8.2.5, so you
can just omit these settings with the standard RPMs)

$ cd /home/laurenz
$ export PATH=3D/magwien/postgres-8.2.5/bin:$PATH
$ tar -xzvf psqlodbc-08.02.0500.tar.gz
$ cd psqlodbc-08.02.0500
$ LDFLAGS=3D-Wl,-rpath,/magwien/postgres-8.2.5/lib ./configure --prefix=3D/=
magwien/postgres-8.2.5
$ make

Install:

# cd /home/laurenz/psqlodbc-08.02.0500
# make install

You wrote that you encountered problems, but did not describe them.

Yours,
Laurenz Albe

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

Albe Laurenz [ Mi, 15 Juli 2009 09:35 ] [ ID #2008616 ]

Re: help compiling psqldobc-08.03.0400

,--- You/Scott (Mon, 13 Jul 2009 15:29:35 -0400) ----*
| Has anyone had any success compiling psqlodbc on Redhat Linux (I'm using
| RHEL AS4).

Yes, of course, like a million times.

| The rest of my information is below. Let me know if there is
| anything else I missed.

You never sent out the full build log, starting with the `configure'
output.

-- Alex -- alex-goncharov [at] comcast.net --

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

Alex Goncharov [ Mi, 15 Juli 2009 14:28 ] [ ID #2008617 ]

Re: help compiling psqldobc-08.03.0400

Thanks for the replies. For some reason my emails have been taking a
couple days to go through on the mailing list. I ended up commenting
out some of the ifdef statements to get it to compile:

In odbcapi.c:

#ifdef WITH_UNIXODBC
SQLROWSETSIZE *pcrow,
#else
SQLULEN *pcrow,
#endif /* WITH_UNIXODBC */

I changed to:

SQLULEN *pcrow,

In odbcapi30.c

#if defined(_WIN64)
SQLLEN *NumericAttribute
#elif defined(WITH_UNIXODBC) || defined(WIN32)
SQLPOINTER NumericAttribute
#else
SQLLEN *NumericAttribute
#endif

I changed to:

SQLLEN *NumericAttribute

And in odbcapi30w.c

#if defined(WITH_UNIXODBC) || (defined(WIN32) && ! defined(_WIN64))
SQLPOINTER pNumAttr
#else
SQLLEN *pNumAttr
#endif

I changed to:

SQLLEN *pNumAttr

For some reason even though I have unixODBC installed it didn't like
those values it was defining. I was able to setup a database link
through oracle and everything seems to be working properly. Hopefully,
this won't cause any issues down the road. I would assume anyone else
trying to compile on redhat 64-bit would have the same issues.

Scott k.

-----Original Message-----
From: Albe Laurenz [mailto:laurenz.albe [at] wien.gv.at]
Sent: Wednesday, July 15, 2009 3:35 AM
To: Kulik, Scott; pgsql-odbc [at] postgresql.org
Subject: RE: [ODBC] help compiling psqldobc-08.03.0400

Scott Kulik wrote:
> Has anyone had any success compiling psqlodbc on Redhat Linux (I'm
using
> RHEL AS4). I have pretty much tried compiling with with every
> combination of odbc and postgres versions but never had any luck.
>
> I've been trying to figure this out for a few weeks but I think we may
> just have to end up paying the $500/server for the openlink
> driver/support.
>
> Anyone have any suggestions that might save us a few thousand dollars?

I never had any problems with it.
This is my log of a session where I installed 08.02.0500 on a 32-bit
RHEL4 machine:

Prerequisites:
(The first two packages are our own RPMs for PostgreSQL, you can use the
standard "libs" and "devel" packages)

# rpm -U adv-postgres-8.2.5-libs-1-1.i386.rpm
# rpm -U adv-postgres-8.2.5-devel-1-1.i386.rpm
# yum install unixODBC unixODBC-devel

Unpack and compile the software:
(Our packages install PostgreSQL into /magwien/postgres-8.2.5, so you
can just omit these settings with the standard RPMs)

$ cd /home/laurenz
$ export PATH=3D/magwien/postgres-8.2.5/bin:$PATH
$ tar -xzvf psqlodbc-08.02.0500.tar.gz
$ cd psqlodbc-08.02.0500
$ LDFLAGS=3D-Wl,-rpath,/magwien/postgres-8.2.5/lib ./configure
--prefix=3D/magwien/postgres-8.2.5
$ make

Install:

# cd /home/laurenz/psqlodbc-08.02.0500
# make install

You wrote that you encountered problems, but did not describe them.

Yours,
Laurenz Albe

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

SKulik [ Mi, 15 Juli 2009 16:05 ] [ ID #2008958 ]