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(dot)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=/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(at)comcast(dot)net]
Sent: Thursday, July 09, 2009 3:42 PM
To: Kulik, Scott
Cc: pgsql-odbc(at)postgresql(dot)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(dot)net --

/*
* Never let someone who says it cannot be done
* interrupt the person who is doing it.
*/