Thread: compiling odbc

compiling odbc

From
Brent Austin
Date:
I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.
Here is what I get:
client-66-xxx-17-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... no
configure: error: pg_config not found (set PG_CONFIG environment variable)

How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"
(I'm relatively new to most of this?
thanks
-B

Re: compiling odbc

From
Tom Lane
Date:
Brent Austin <brent1a@yahoo.com> writes:
> I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.
> checking for pg_config... no
> configure: error: pg_config not found (set PG_CONFIG environment variable)

> How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"

Probably means you don't have Postgres itself installed.  On some
platforms it could mean that you don't have the postgresql-devel
subpackage installed, but I've not heard that anyone divides up the
package like that on OS X.

Another possibility is that PG is installed, but in a directory
that's not in your PATH.

            regards, tom lane

Re: compiling odbc

From
Brent Austin
Date:

I just installed the latest Postgres from source so everything needed should be there. Some of the things I've been installing recently have not had the right PATH but I thought I fixed that. What would fix this problem?
I think postgres is installed in:
/usr/local/psql

would this fix it:

export PATH=$PATH:/usr/local/psql

or maybe

echo "export PATH=\"/usr/local/psql:$PATH\"" >> .bash_profile


----- Original Message ----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Brent Austin <brent1a@yahoo.com>
Cc: pgsql-odbc@postgresql.org
Sent: Thursday, September 18, 2008 1:52:00 PM
Subject: Re: [ODBC] compiling odbc

Brent Austin <brent1a@yahoo.com> writes:
> I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.
> checking for pg_config... no
> configure: error: pg_config not found (set PG_CONFIG environment variable)

> How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"

Probably means you don't have Postgres itself installed.  On some
platforms it could mean that you don't have the postgresql-devel
subpackage installed, but I've not heard that anyone divides up the
package like that on OS X.

Another possibility is that PG is installed, but in a directory
that's not in your PATH.

            regards, tom lane


Re: compiling odbc

From
Brent Austin
Date:
My pg_config file is in:  /usr/local/pgsql/bin  so how do I tell terminal to see that it's there instead of where it thinks it is?


----- Original Message ----
From: Brent Austin <brent1a@yahoo.com>
To: pgsql-odbc@postgresql.org
Sent: Thursday, September 18, 2008 2:15:07 PM
Subject: Re: [ODBC] compiling odbc


I just installed the latest Postgres from source so everything needed should be there. Some of the things I've been installing recently have not had the right PATH but I thought I fixed that. What would fix this problem?
I think postgres is installed in:
/usr/local/psql

would this fix it:

export PATH=$PATH:/usr/local/psql

or maybe

echo "export PATH=\"/usr/local/psql:$PATH\"" >> .bash_profile


----- Original Message ----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Brent Austin <brent1a@yahoo.com>
Cc: pgsql-odbc@postgresql.org
Sent: Thursday, September 18, 2008 1:52:00 PM
Subject: Re: [ODBC] compiling odbc

Brent Austin <brent1a@yahoo.com> writes:
> I am attempting to compile and install psqlodbc-08.03.0200 on my Mac Pro running Leopard.
> checking for pg_config... no
> configure: error: pg_config not found (set PG_CONFIG environment variable)

> How do I fix "configure: error: pg_config not found (set PG_CONFIG environment variable)"

Probably means you don't have Postgres itself installed.  On some
platforms it could mean that you don't have the postgresql-devel
subpackage installed, but I've not heard that anyone divides up the
package like that on OS X.

Another possibility is that PG is installed, but in a directory
that's not in your PATH.

            regards, tom lane



Re: compiling odbc

From
"Albe Laurenz"
Date:
Brent Austin wrote:
> My pg_config file is in:  /usr/local/pgsql/bin  so how do I
> tell terminal to see that it's there instead of where it thinks it is?
>
> would this fix it:
>
> export PATH=$PATH:/usr/local/psql

Erm, no.
Try:

export PATH=$PATH:/usr/local/psql/bin

Yours,
Laurenz Albe

Re: compiling odbc

From
Brent Austin
Date:
So far this is what I get when I try that command-

client-66-1xx-17-xx4:~ brent1a$ export PATH=$PATH:/usr/local/psql/bin

client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200 

client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure

Password:

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... no

configure: error: pg_config not found (set PG_CONFIG environment variable)

client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ 


----- Original Message ----
From: Albe Laurenz <laurenz.albe@wien.gv.at>
To: Brent Austin *EXTERN* <brent1a@yahoo.com>; pgsql-odbc@postgresql.org
Sent: Friday, September 19, 2008 1:35:20 AM
Subject: RE: [ODBC] compiling odbc

Brent Austin wrote:
> My pg_config file is in:  /usr/local/pgsql/bin  so how do I
> tell terminal to see that it's there instead of where it thinks it is?
>
> would this fix it:
>
> export PATH=$PATH:/usr/local/psql

Erm, no.
Try:

export PATH=$PATH:/usr/local/psql/bin

Yours,
Laurenz Albe

Re: compiling odbc

From
"Albe Laurenz"
Date:
> So far this is what I get when I try that command-
>
> client-66-1xx-17-xx4:~ brent1a$ export PATH=$PATH:/usr/local/psql/bin
>
> client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200
>
> client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure
>
[...]
>
> configure: error: pg_config not found (set PG_CONFIG environment variable)

Yeah, sure.

You should omit the "sudo", it's wrong.

But maybe it's best to follow the instructions you get and
export PG_CONFIG=/usr/local/psql/bin/pg_config

Yours,
Laurenz Albe

Re: compiling odbc

From
Jeremy Faith
Date:
Hi,

Brent Austin wrote:
> My pg_config file is in:  /usr/local/pgsql/bin  so how do I
> tell terminal to see that it's there instead of where it thinks it is?
>
> would this fix it:
>
> export PATH=$PATH:/usr/local/psql

Could this be as simple as the 'g' being missing from the pgsql directory in the PATH?
i.e.
  export PATH=$PATH:/usr/local/psql
should be
  export PATH=$PATH:/usr/local/pgsql
and
  export PG_CONFIG=/usr/local/psql/bin/pg_config
should be
  export PG_CONFIG=/usr/local/pgsql/bin/pg_config

Regards,
Jeremy Faith


Albe Laurenz wrote:
>> So far this is what I get when I try that command-
>>
>> client-66-1xx-17-xx4:~ brent1a$ export PATH=$PATH:/usr/local/psql/bin
>>
>> client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200
>>
>> client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure
>>
>>
> [...]
>
>> configure: error: pg_config not found (set PG_CONFIG environment variable)
>>
>
> Yeah, sure.
>
> You should omit the "sudo", it's wrong.
>
> But maybe it's best to follow the instructions you get and
> export PG_CONFIG=/usr/local/psql/bin/pg_config
>
> Yours,
> Laurenz Albe
>
>


Re: compiling odbc

From
Brent Austin
Date:
I got export PATH=$PATH:/usr/local/pgsql to work

but now I get:
"configure: error: unixODBC library "odbcinst" not found"

I found that "odbcinst" is in my /opt/local/bin

How do I tell configure that pgsql is in /usr/local/pgsql and ALSO tell it that obcinst is in /opt/local/bin ???




----- Original Message ----
From: Jeremy Faith <jfaith@cemsys.com>
To: pgsql-odbc@postgresql.org
Sent: Friday, September 19, 2008 6:35:23 AM
Subject: Re: [ODBC] compiling odbc

Hi,

Brent Austin wrote:
> My pg_config file is in:  /usr/local/pgsql/bin  so how do I
> tell terminal to see that it's there instead of where it thinks it is?
>
> would this fix it:
>
> export PATH=$PATH:/usr/local/psql

Could this be as simple as the 'g' being missing from the pgsql directory in the PATH?
i.e.
  export PATH=$PATH:/usr/local/psql
should be
  export PATH=$PATH:/usr/local/pgsql
and
  export PG_CONFIG=/usr/local/psql/bin/pg_config
should be
  export PG_CONFIG=/usr/local/pgsql/bin/pg_config

Regards,
Jeremy Faith


Albe Laurenz wrote:
>> So far this is what I get when I try that command-
>>
>> client-66-1xx-17-xx4:~ brent1a$ export PATH=$PATH:/usr/local/psql/bin
>>
>> client-66-1xx-17-xx4:~ brent1a$ cd /psqlodbc-08.03.0200
>>
>> client-66-1xx-17-xx4:psqlodbc-08.03.0200 brent1a$ sudo ./configure
>>
>>   
> [...]

>> configure: error: pg_config not found (set PG_CONFIG environment variable)
>>   
>
> Yeah, sure.
>
> You should omit the "sudo", it's wrong.
>
> But maybe it's best to follow the instructions you get and
> export PG_CONFIG=/usr/local/psql/bin/pg_config
>
> Yours,
> Laurenz Albe
>



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

Re: compiling odbc

From
Tom Lane
Date:
Brent Austin <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

Re: compiling odbc

From
Brent Austin
Date:
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>
To: Brent Austin <brent1a@yahoo.com>
Cc: Jeremy Faith <jfaith@cemsys.com>; pgsql-odbc@postgresql.org
Sent: Friday, September 19, 2008 3:11:36 PM
Subject: Re: [ODBC] compiling odbc

Brent Austin <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

Re: compiling odbc

From
Jeremy Faith
Date:
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>
> To: Brent Austin <brent1a@yahoo.com>
> Cc: Jeremy Faith <jfaith@cemsys.com>; 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>> 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
>


Re: compiling odbc

From
Brent Austin
Date:
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$ 


----- 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>
> To: Brent Austin <brent1a@yahoo.com>
> Cc: Jeremy Faith <jfaith@cemsys.com>; 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>> 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)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: compiling odbc

From
Zoltan Boszormenyi
Date:
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/


Re: compiling odbc

From
Brent Austin
Date:
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/


Re: compiling odbc

From
Peter Eisentraut
Date:
Brent Austin wrote:
> 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.

Try something like

export LDFLAGS=-L/opt/local/lib


Re: compiling odbc

From
"Hiroshi Saito"
Date:
> Brent Austin wrote:
>> 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.
>
> Try something like
>
> export LDFLAGS=-L/opt/local/lib

Yeah, or they must be found odbc_config(unixODBC) by configure.

unixODBC is this
hiroshi@developer:~$ which odbc_config
/usr/local/bin/odbc_config
hiroshi@developer:~$ odbc_config --libs
-L/usr/local/lib -lodbc

iODBC is this.
inet% which iodbc-config
/usr/local/bin/iodbc-config
inet% iodbc-config --libs
-L/usr/local/lib  -liodbc -liodbcinst

Brent-san, are they found from your path?

Regards,
Hiroshi Saito