Thread: building psqlodbc-07.03.0260 failed: "no suitable ODBC driver manager found"

hi,all:

I tried to build psqlodbc-07.03.0260 on FreeBSD 5.4(i386 machine) but failed.

When I run "./configure --with-unixodbc" in the psqlodbc source dir and the following was given:

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... nawk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for style of include used by make... GNU
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking dependency style of gcc... gcc3
checking for SQLGetPrivateProfileString in -lodbcinst... no
configure: error: unixODBC driver manager not found

I have already installed unixODBC-2.2.11 which is working well on my machine.

But ,what is the problem of building psqlodbc and how can i fix it?

Yours,
Lestat

From: "Lee Rubao"

> I have already installed unixODBC-2.2.11 which is working well on my
> machine.
>
> But ,what is the problem of building psqlodbc and how can i fix it?

Umm, Is the directory which you installed contained in path?
Although odbc_config shows the place, is there?
or place of libodbcinst.a....
configure looks for SQLGetPrivateProfileString of odbcinst.

Regards,
Hiroshi Saito

> > I have already installed unixODBC-2.2.11 which is working well on my
> > machine.
> >
> > But ,what is the problem of building psqlodbc and how can i fix it?
>
> Umm, Is the directory which you installed contained in path?
> Although odbc_config shows the place, is there?
> or place of libodbcinst.a....
> configure looks for SQLGetPrivateProfileString of odbcinst.

Ahh, Some supplement.
Please see CONFIG_sample.txt

CPPFLAGS="-I/usr/local/include -I/usr/local/pgsql/include -I/usr/include/openssl"
LDFLAGS="-L/usr/local/lib -L/usr/local/pgsql/lib"
export CPPFLAGS LDFLAGS
configure --enable-unicode --with-unixodbc --with-odbcver=0x0300 --enable-pthreads

Furthermore, Please check of LD_LIBRARY_PATH at the time of execution.

Regards,
Hiroshi Saito

Thank you. I finished the compilation with LDFLAGS = -L/usr/local/lib.