Thread: Configuration error in psqlodbc-09.02.0100 . Help needed!
Hi All,
I am trying to install psqlodbc-09.02.0100 in linux server – “Linux benchmarker1 2.6.18-8.el5PAE #1 SMP Fri Jan 26 14:28:43 EST 2007 i686 i686 i386 GNU/Linux” , from source and while running “./configure” , am getting below output and it fails with error message “configure: error: unixODBC library "odbcinst" not found”
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /bin/mkdir -p
checking for gawk... gawk
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 whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
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 ISO C89... none needed
checking dependency style of gcc... gcc3
checking for pg_config... no
checking for gcc... (cached) gcc
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking for gcc option to accept ISO C89... (cached) none needed
checking dependency style of gcc... (cached) gcc3
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking how to print strings... printf
checking for a sed that does not truncate output... /bin/sed
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for fgrep... /bin/grep -F
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B
checking the name lister (/usr/bin/nm -B) interface... BSD nm
checking whether ln -s works... yes
checking the maximum length of command line arguments... 98304
checking whether the shell understands some XSI constructs... yes
checking whether the shell understands "+="... yes
checking how to convert i686-pc-linux-gnu file names to i686-pc-linux-gnu format... func_convert_file_noop
checking how to convert i686-pc-linux-gnu file names to toolchain format... func_convert_file_noop
checking for /usr/bin/ld option to reload object files... -r
checking for objdump... objdump
checking how to recognize dependent libraries... pass_all
checking for dlltool... dlltool
checking how to associate runtime and link libraries... printf %s\n
checking for ar... ar
checking for archiver @FILE support... @
checking for strip... strip
checking for ranlib... ranlib
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for sysroot... no
checking for mt... mt
checking if mt is a manifest tool... no
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for dlfcn.h... yes
checking for objdir... .libs
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC -DPIC
checking if gcc PIC flag -fPIC -DPIC works... yes
checking if gcc static flag -static works... yes
checking if gcc supports -c -o file.o... yes
checking if gcc supports -c -o file.o... (cached) yes
checking whether the gcc linker (/usr/bin/ld) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking for shl_load... no
checking for shl_load in -ldld... no
checking for dlopen... no
checking for dlopen in -ldl... yes
checking whether a program can dlopen itself... yes
checking whether a statically linked program can dlopen itself... no
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... no
checking for library containing SQLGetPrivateProfileString... no
configure: error: unixODBC library "odbcinst" not found
Could anyone help me to resolve this issue?
And I see odbc is installed in the server. For the command “odbc_config –libs”, I get the output “-L/usr/lib –lodbc”
Am new to this forum and sorry if this question is already raised and resolved in this forum.
Thanks & Regards,
Vaishnavi
(2013/11/05 14:32), Prabakaran, Vaishnavi wrote: > Hi All, > > I am trying to install psqlodbc-09.02.0100 in linux server – “Linux > benchmarker1 2.6.18-8.el5PAE #1 SMP Fri Jan 26 14:28:43 EST 2007 i686 > i686 i386 GNU/Linux” , from source and while running “./configure” , am > getting below output and it fails with error message “configure: error: > unixODBC library "odbcinst" not found” Please specify --with-unixodbc option explicitly. regards, Hiroshi Inoue
-----Original Message----- From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Inoue, Hiroshi Sent: Tuesday, 5 November 2013 8:01 PM To: Prabakaran, Vaishnavi; pgsql-odbc@postgresql.org Subject: Re: [ODBC] Configuration error in psqlodbc-09.02.0100 . Help needed! (2013/11/05 14:32), Prabakaran, Vaishnavi wrote: > Hi All, > > I am trying to install psqlodbc-09.02.0100 in linux server - "Linux > benchmarker1 2.6.18-8.el5PAE #1 SMP Fri Jan 26 14:28:43 EST 2007 i686 > i686 i386 GNU/Linux" , from source and while running "./configure" , > am getting below output and it fails with error message "configure: error: > unixODBC library "odbcinst" not found" >Please specify --with-unixodbc option explicitly. ./configure --help says below line, --with-unixodbc=DIR odbc_config installation of unixODBC (default) So, I have specified as "./configure --with-unixodbc=/usr/bin" , but got the error ==> configure: error: odbc_config not found (required for unixODBC build). I verified the configure script and it tries to search in bin folder for odbc_config, so this time, I tried giving ./configure --with-unixodbc=/usr/ , but got the same old error ==> "configure: error: unixODBC library "odbcinst" not found" Could you kindly give suggestion to resolve this? Thanks & Regards, Vaishnavi >regards, >Hiroshi Inoue -- Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-odbc
On 11/05/2013 02:32 PM, Prabakaran, Vaishnavi wrote: > -----Original Message----- > From: pgsql-odbc-owner@postgresql.org > [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Inoue, Hiroshi > Sent: Tuesday, 5 November 2013 8:01 PM > To: Prabakaran, Vaishnavi; pgsql-odbc@postgresql.org > Subject: Re: [ODBC] Configuration error in psqlodbc-09.02.0100 . Help > needed! > > (2013/11/05 14:32), Prabakaran, Vaishnavi wrote: >> Hi All, >> >> I am trying to install psqlodbc-09.02.0100 in linux server - "Linux >> benchmarker1 2.6.18-8.el5PAE #1 SMP Fri Jan 26 14:28:43 EST 2007 i686 >> i686 i386 GNU/Linux" , from source and while running "./configure" , >> am getting below output and it fails with error message "configure: > error: >> unixODBC library "odbcinst" not found" > >> Please specify --with-unixodbc option explicitly. > > ./configure --help says below line, > --with-unixodbc=DIR odbc_config installation of unixODBC (default) > > So, I have specified as "./configure --with-unixodbc=/usr/bin" , but got > the error ==> configure: error: odbc_config not found (required for > unixODBC build). > I verified the configure script and it tries to search in bin folder for > odbc_config, so this time, I tried giving > ./configure --with-unixodbc=/usr/ , but got the same old error ==> > "configure: error: unixODBC library "odbcinst" not found" > > Could you kindly give suggestion to resolve this? Do you have the unixODBC-devel libraries installed? > > Thanks & Regards, > Vaishnavi > >> regards, >> Hiroshi Inoue > > > > > > > -- > Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make > changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-odbc > > > > -- Adrian Klaver adrian.klaver@gmail.com
On 11/05/2013 02:32 PM, Prabakaran, Vaishnavi wrote: > -----Original Message----- > From: pgsql-odbc-owner@postgresql.org > [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Inoue, Hiroshi > Sent: Tuesday, 5 November 2013 8:01 PM > To: Prabakaran, Vaishnavi; pgsql-odbc@postgresql.org > Subject: Re: [ODBC] Configuration error in psqlodbc-09.02.0100 . Help > needed! > > (2013/11/05 14:32), Prabakaran, Vaishnavi wrote: >> Hi All, >> >> I am trying to install psqlodbc-09.02.0100 in linux server - "Linux >> benchmarker1 2.6.18-8.el5PAE #1 SMP Fri Jan 26 14:28:43 EST 2007 i686 >> i686 i386 GNU/Linux" , from source and while running "./configure" , >> am getting below output and it fails with error message "configure: > error: >> unixODBC library "odbcinst" not found" > >> Please specify --with-unixodbc option explicitly. > > ./configure --help says below line, > --with-unixodbc=DIR odbc_config installation of unixODBC (default) > > So, I have specified as "./configure --with-unixodbc=/usr/bin" , but got > the error ==> configure: error: odbc_config not found (required for > unixODBC build). > I verified the configure script and it tries to search in bin folder for > odbc_config, so this time, I tried giving > ./configure --with-unixodbc=/usr/ , but got the same old error ==> > "configure: error: unixODBC library "odbcinst" not found" > > Could you kindly give suggestion to resolve this? Well just tried here and a bare ./configure worked. Doing: ./configure --with-unixodbc=/usr/bin failed with the same error. To get it to work I did: ./configure --with-unixodbc=/usr/bin/odbc_config > > Thanks & Regards, > Vaishnavi > >> regards, >> Hiroshi Inoue > > > > > > > -- > Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make > changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-odbc > > > > -- Adrian Klaver adrian.klaver@gmail.com
-----Original Message----- >From: Adrian Klaver [mailto:adrian.klaver@gmail.com] >Sent: Wednesday, 6 November 2013 10:33 AM >To: Prabakaran, Vaishnavi; Inoue, Hiroshi; pgsql-odbc@postgresql.org >Subject: Re: [ODBC] Configuration error in psqlodbc-09.02.0100 . Help needed! >On 11/05/2013 02:32 PM, Prabakaran, Vaishnavi wrote: >> -----Original Message----- > >From: pgsql-odbc-owner@postgresql.org > > [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Inoue, Hiroshi > >Sent: Tuesday, 5 November 2013 8:01 PM > >To: Prabakaran, Vaishnavi; pgsql-odbc@postgresql.org > >Subject: Re: [ODBC] Configuration error in psqlodbc-09.02.0100 . Help > >needed! >> >> (2013/11/05 14:32), Prabakaran, Vaishnavi wrote: >>> Hi All, >>> >> >I am trying to install psqlodbc-09.02.0100 in linux server - "Linux >> >benchmarker1 2.6.18-8.el5PAE #1 SMP Fri Jan 26 14:28:43 EST 2007 i686 >> >i686 i386 GNU/Linux" , from source and while running "./configure" , >> >am getting below output and it fails with error message "configure: > >error: >> >unixODBC library "odbcinst" not found" >> >>> Please specify --with-unixodbc option explicitly. >> > >./configure --help says below line, > > --with-unixodbc=DIR odbc_config installation of unixODBC (default) >> > >So, I have specified as "./configure --with-unixodbc=/usr/bin" , but > >got the error ==> configure: error: odbc_config not found (required > >for unixODBC build). > >I verified the configure script and it tries to search in bin folder > >for odbc_config, so this time, I tried giving ./configure > >--with-unixodbc=/usr/ , but got the same old error ==> > >"configure: error: unixODBC library "odbcinst" not found" >> >> Could you kindly give suggestion to resolve this? >Well just tried here and a bare ./configure worked. Doing: >./configure --with-unixodbc=/usr/bin >failed with the same error. >To get it to work I did: >./configure --with-unixodbc=/usr/bin/odbc_config Yes, the second option did worked for me. Thanks a lot. >> >> Thanks & Regards, >> Vaishnavi >> >>> regards, >> >Hiroshi Inoue >> >> >> >> >> >> > >-- > >Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make > >changes to your subscription: > >http://www.postgresql.org/mailpref/pgsql-odbc >> >> >> >> --> >Adrian Klaver >adrian.klaver@gmail.com Best Regards, Vaishnavi
Hi, On Tue, 2013-11-05 at 18:32 +1300, Prabakaran, Vaishnavi wrote: > I am trying to install psqlodbc-09.02.0100 in linux server - "Linux > benchmarker1 2.6.18-8.el5PAE #1 SMP Fri Jan 26 14:28:43 EST 2007 i686 > i686 i386 GNU/Linux" , from source and while running "./configure" , > am getting below output and it fails with error message "configure: > error: unixODBC library "odbcinst" not found" Next time, you may want to use the RPMS from http://yum.postgresql.org , so that you won't have to compile. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz