Re: [ODBC] compiling odbc

That's the thing, I have unixODBC installed, it is located at /opt/local/bin that is why I need help figuring out how to get the terminal to recognize where both pg_config AND obdcinst are at during the ./configure process.  

PATH=$PATH:/usr/local/pgsql/bin:/opt/local/bin   should work but it's not recognizing the second part.....the odncinst part.

----- Original Message ----
From: Zoltan Boszormenyi <zb@cybertec.at>
To: Brent Austin <brent1a@yahoo.com>
Cc: Jeremy Faith <jfaith@cemsys.com>; pgsql-odbc@postgresql.org
Sent: Monday, September 22, 2008 5:36:19 AM
Subject: Re: [ODBC] compiling odbc

Brent Austin írta:
> I still get this:   
> client-66-1xx-1x-x14:~ brent1a$
> PATH=$PATH:/usr/local/pgsql/bin:/opt/local/bin
> client-66-1xx-1x-x14:~ brent1a$ cd /psqlodbc-08.03.0200
> client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$ sudo ./configure
> checking for a BSD-compatible install... /usr/bin/install -c
> checking whether build environment is sane... yes
> checking for gawk... no
> checking for mawk... no
> checking for nawk... no
> checking for awk... awk
> checking whether make sets $(MAKE)... yes
> checking whether to enable maintainer-specific portions of Makefiles... no
> checking for pg_config... /usr/local/pgsql/bin/pg_config
> checking for gcc... gcc
> ...........
> checking how to hardcode library paths into programs... immediate
> checking for library containing SQLGetPrivateProfileString... no
> *configure: error: unixODBC library "odbcinst" not found*
> client-66-1xx-1x-x14:psqlodbc-08.03.0200 brent1a$

You need unixODBC or iODBC installed. unixODBC is used by default,
you can change the expected ODBC manager with option --with-iodbc.

> ----- Original Message ----
> From: Jeremy Faith <jfaith@cemsys.com>
> To: pgsql-odbc@postgresql.org
> Sent: Monday, September 22, 2008 4:06:28 AM
> Subject: Re: [ODBC] compiling odbc
>
> Hi,
>
> I think what Tom is saying is to try:-
>  PATH=$PATH:/usr/local/pgsql:/opt/local/bin
>
> Regards,
> Jeremy Faith
>
> Brent Austin wrote:
> > Yes, two PATH items, I guess.
> > "export PATH=$PATH:/usr/local/pgsql"
> >
> > takes care of:
> >
> > "checking for pg_config... no
> > configure: error: pg_config not found (set PG_CONFIG environment
> > variable)"
> >
> > How can I take care of the following as well with out messing up the
> > above?
> >
> > "configure: error: unixODBC library "odbcinst" not found"
> >
> > (I found "odbcinst" is in my /opt/local/bin)
> >
> > ----- Original Message ----
> > From: Tom Lane <tgl@sss.pgh.pa.us <mailto:tgl@sss.pgh.pa.us>>
> > To: Brent Austin <brent1a@yahoo.com <mailto:brent1a@yahoo.com>>
> > Cc: Jeremy Faith <jfaith@cemsys.com <mailto:jfaith@cemsys.com>>;
> pgsql-odbc@postgresql.org <mailto:pgsql-odbc@postgresql.org>
> > Sent: Friday, September 19, 2008 3:11:36 PM
> > Subject: Re: [ODBC] compiling odbc
> >
> > Brent Austin <brent1a@yahoo.com <mailto:brent1a@yahoo.com>
> <mailto:brent1a@yahoo.com <mailto:brent1a@yahoo.com>>> writes:
> > > How do I tell configure that pgsql is in /usr/local/pgsql and ALSO
> > tell it that obcinst is in /opt/local/bin ???
> >
> > Two PATH items?
> >
> >            regards, tom lane
> >
>
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org
> <mailto:pgsql-odbc@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>


--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/