Thread: Compile Errors on Mac OS X 10.14.6 (fatal error: 'iODBC/sqltypes.h'file not found)

Compile Errors on Mac OS X 10.14.6 (fatal error: 'iODBC/sqltypes.h'file not found)

From
Christoph Gößmann
Date:
Dear PostgreSQL ODBC driver team,

I would like to use the ODBC driver together with iODBC.

As for the steps that I performed so far, I installed iODBC using the installer provided on the webpage
(http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads#Mac%20OS%20X),and then went ahead trying to compile
thedriver: 
=============================================
wget https://ftp.postgresql.org/pub/odbc/versions/src/psqlodbc-12.00.0000.tar.gz
tar -zxvf psqlodbc-12.00.0000.tar.gz
./configure --with-iodbc=/usr/local/iODBC/


The folder /usr/local/iODBC/ contains the following folders/files:
=============================================
/include
  odbcinst.h
  iodbcinst.h
  sqlucode.h
  sqltypes.h
  sqlext.h
  sql.h
  isqltypes.h
  isqlext.h
  isql.h
  iodbcunix.h
  iodbcext.h
  iodbc.h
/lib
  libiodbcinst.dylib
  libiodbc.dylib
/bin
  iodbc-config


This is the output (for error, scroll down to the $ make part):
=============================================
$ ./configure --with-iodbc=/usr/local/iODBC/
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... config/install-sh -c -d
checking for gawk... no
checking for mawk... no
checking for nawk... no
checking for awk... awk
checking whether make sets $(MAKE)... yes
checking whether make supports nested variables... yes
checking whether to enable maintainer-specific portions of Makefiles... no
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 whether gcc understands -c and -o together... yes
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking -Wall is a valid compile option... yes
configure: using -I/usr/local/iODBC/include -L/usr/local/iODBC/lib  -liodbc -liodbcinst
configure: using -L/usr/local/iODBC/lib  -liodbc -liodbcinst for regression test
checking last argument to SQLColAttribute is SQLLEN *... no
checking for pg_config... /Users/chg/anaconda3/bin/pg_config
checking for prove... prove
checking build system type... x86_64-apple-darwin18.7.0
checking host system type... x86_64-apple-darwin18.7.0
configure: WARNING: Libtool does not cope well with whitespace in `pwd`
checking how to print strings... printf
checking for a sed that does not truncate output... /usr/bin/sed
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for fgrep... /usr/bin/grep -F
checking for ld used by gcc... /Library/Developer/CommandLineTools/usr/bin/ld
checking if the linker (/Library/Developer/CommandLineTools/usr/bin/ld) is GNU ld... no
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... 196608
checking whether the shell understands some XSI constructs... yes
checking whether the shell understands "+="... yes
checking how to convert x86_64-apple-darwin18.7.0 file names to x86_64-apple-darwin18.7.0 format...
func_convert_file_noop
checking how to convert x86_64-apple-darwin18.7.0 file names to toolchain format... func_convert_file_noop
checking for /Library/Developer/CommandLineTools/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... no
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... no
checking if : is a manifest tool... no
checking for dsymutil... dsymutil
checking for nmedit... nmedit
checking for lipo... lipo
checking for otool... otool
checking for otool64... no
checking for -single_module linker flag... yes
checking for -exported_symbols_list linker flag... yes
checking for -force_load linker flag... yes
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... yes
checking for gcc option to produce PIC... -fno-common -DPIC
checking if gcc PIC flag -fno-common -DPIC works... yes
checking if gcc static flag -static works... no
checking if gcc supports -c -o file.o... yes
checking if gcc supports -c -o file.o... (cached) yes
checking whether the gcc linker (/Library/Developer/CommandLineTools/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... darwin18.7.0 dyld
checking how to hardcode library paths into programs... immediate
checking for dlopen in -ldl... yes
checking whether a program can dlopen itself... yes
checking whether a statically linked program can dlopen itself... yes
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... none required
checking for pthread_create in -lpthreads... no
checking for pthread_create in -lpthread... yes
checking for PQsetSingleRowMode in -lpq... yes
checking locale.h usability... yes
checking locale.h presence... yes
checking for locale.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking uchar.h usability... no
checking uchar.h presence... no
checking for uchar.h... no
checking libpq-fe.h usability... yes
checking libpq-fe.h presence... yes
checking for libpq-fe.h... yes
checking whether time.h and sys/time.h may both be included... yes
checking size of long... 8
checking size of long int... 8
checking size of void *... 8
checking for long long... yes
checking for signed char... yes
checking for ssize_t... yes
checking for size_t... yes
checking whether struct tm is in sys/time.h or time.h... time.h
checking for an ANSI C-conforming const... yes
checking whether strerror_r is declared... yes
checking for strerror_r... yes
checking whether strerror_r returns char *... no
checking for strtoul... yes
checking for strtoll... yes
checking for strlcat... yes
checking for mbstowcs... yes
checking for wcstombs... yes
checking for mbrtoc16... no
checking for c16rtomb... no
checking for localtime_r... yes
checking for strtok_r... yes
checking for pthread_mutexattr_settype... yes
checking that generated files are newer than configure... done
configure: creating ./config.status
config.status: creating Makefile
config.status: creating test/Makefile
config.status: creating config.h
config.status: config.h is unchanged
config.status: executing depfiles commands
config.status: executing libtool commands

$ make
make  all-am
make[1]: Entering directory '/Users/chg/.Trash/psqlodbc-12.00.0000 19.09.26'
/bin/sh ./libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I.   -I/usr/local/iODBC/include
-I/Users/chg/anaconda3/include-I/Users/chg/anaconda3/include/internal -DUNICODE_SUPPORT  -g -O2 -Wall -MT
psqlodbcw_la-info.lo-MD -MP -MF .deps/psqlodbcw_la-info.Tpo -c -o psqlodbcw_la-info.lo `test -f 'info.c' || echo
'./'`info.c
libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I/usr/local/iODBC/include -I/Users/chg/anaconda3/include
-I/Users/chg/anaconda3/include/internal-DUNICODE_SUPPORT -g -O2 -Wall -MT psqlodbcw_la-info.lo -MD -MP -MF
.deps/psqlodbcw_la-info.Tpo-c info.c  -fno-common -DPIC -o .libs/psqlodbcw_la-info.o 
In file included from info.c:19:
In file included from ./psqlodbc.h:112:
/usr/local/iODBC/include/sql.h:89:10: fatal error: 'iODBC/sqltypes.h' file not found
#include <iODBC/sqltypes.h>
        ^~~~~~~~~~~~~~~~~~
1 error generated.
make[1]: *** [Makefile:657: psqlodbcw_la-info.lo] Error 1
make[1]: Leaving directory '/Users/chg/.Trash/psqlodbc-12.00.0000 19.09.26'
make: *** [Makefile:479: all] Error 2


I also tried with /usr/local/ for the path … the error then is  "./psqlodbc.h:136:10: fatal error: 'iodbcinst.h' file
notfound” instead. 

Since my experience with C(++) and compiling is pretty limited, I appreciate any help!

Thanks,
Christoph


Hi Christoph,

On 2019/10/16 2:43, Christoph Gößmann wrote:
> Dear PostgreSQL ODBC driver team,
>
> I would like to use the ODBC driver together with iODBC.
>
> As for the steps that I performed so far, I installed iODBC using the installer provided on the webpage
(http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads#Mac%20OS%20X),and then went ahead trying to compile
thedriver:
 
> =============================================
> wget https://ftp.postgresql.org/pub/odbc/versions/src/psqlodbc-12.00.0000.tar.gz
> tar -zxvf psqlodbc-12.00.0000.tar.gz
> ./configure --with-iodbc=/usr/local/iODBC/
>
>
> The folder /usr/local/iODBC/ contains the following folders/files:
> =============================================
> /include
>    odbcinst.h
>    iodbcinst.h
>    sqlucode.h
>    sqltypes.h
>    sqlext.h
>    sql.h
>    isqltypes.h
>    isqlext.h
>    isql.h
>    iodbcunix.h
>    iodbcext.h
>    iodbc.h
> /lib
>    libiodbcinst.dylib
>    libiodbc.dylib
> /bin
>    iodbc-config
>
>
> This is the output (for error, scroll down to the $ make part):
> =============================================
> $ ./configure --with-iodbc=/usr/local/iODBC/
> checking for a BSD-compatible install... /usr/bin/install -c
> checking whether build environment is sane... yes
> checking for a thread-safe mkdir -p... config/install-sh -c -d
> checking for gawk... no
> checking for mawk... no
> checking for nawk... no
> checking for awk... awk
> checking whether make sets $(MAKE)... yes
> checking whether make supports nested variables... yes
> checking whether to enable maintainer-specific portions of Makefiles... no
> 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 whether gcc understands -c and -o together... yes
> checking for style of include used by make... GNU
> checking dependency style of gcc... gcc3
> checking -Wall is a valid compile option... yes
> configure: using -I/usr/local/iODBC/include -L/usr/local/iODBC/lib  -liodbc -liodbcinst
> configure: using -L/usr/local/iODBC/lib  -liodbc -liodbcinst for regression test
> checking last argument to SQLColAttribute is SQLLEN *... no
> checking for pg_config... /Users/chg/anaconda3/bin/pg_config
> checking for prove... prove
> checking build system type... x86_64-apple-darwin18.7.0
> checking host system type... x86_64-apple-darwin18.7.0
> configure: WARNING: Libtool does not cope well with whitespace in `pwd`
> checking how to print strings... printf
> checking for a sed that does not truncate output... /usr/bin/sed
> checking for grep that handles long lines and -e... /usr/bin/grep
> checking for egrep... /usr/bin/grep -E
> checking for fgrep... /usr/bin/grep -F
> checking for ld used by gcc... /Library/Developer/CommandLineTools/usr/bin/ld
> checking if the linker (/Library/Developer/CommandLineTools/usr/bin/ld) is GNU ld... no
> 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... 196608
> checking whether the shell understands some XSI constructs... yes
> checking whether the shell understands "+="... yes
> checking how to convert x86_64-apple-darwin18.7.0 file names to x86_64-apple-darwin18.7.0 format...
func_convert_file_noop
> checking how to convert x86_64-apple-darwin18.7.0 file names to toolchain format... func_convert_file_noop
> checking for /Library/Developer/CommandLineTools/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... no
> 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... no
> checking if : is a manifest tool... no
> checking for dsymutil... dsymutil
> checking for nmedit... nmedit
> checking for lipo... lipo
> checking for otool... otool
> checking for otool64... no
> checking for -single_module linker flag... yes
> checking for -exported_symbols_list linker flag... yes
> checking for -force_load linker flag... yes
> 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... yes
> checking for gcc option to produce PIC... -fno-common -DPIC
> checking if gcc PIC flag -fno-common -DPIC works... yes
> checking if gcc static flag -static works... no
> checking if gcc supports -c -o file.o... yes
> checking if gcc supports -c -o file.o... (cached) yes
> checking whether the gcc linker (/Library/Developer/CommandLineTools/usr/bin/ld) supports shared libraries... yes
> checking dynamic linker characteristics... darwin18.7.0 dyld
> checking how to hardcode library paths into programs... immediate
> checking for dlopen in -ldl... yes
> checking whether a program can dlopen itself... yes
> checking whether a statically linked program can dlopen itself... yes
> 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... none required
> checking for pthread_create in -lpthreads... no
> checking for pthread_create in -lpthread... yes
> checking for PQsetSingleRowMode in -lpq... yes
> checking locale.h usability... yes
> checking locale.h presence... yes
> checking for locale.h... yes
> checking sys/time.h usability... yes
> checking sys/time.h presence... yes
> checking for sys/time.h... yes
> checking uchar.h usability... no
> checking uchar.h presence... no
> checking for uchar.h... no
> checking libpq-fe.h usability... yes
> checking libpq-fe.h presence... yes
> checking for libpq-fe.h... yes
> checking whether time.h and sys/time.h may both be included... yes
> checking size of long... 8
> checking size of long int... 8
> checking size of void *... 8
> checking for long long... yes
> checking for signed char... yes
> checking for ssize_t... yes
> checking for size_t... yes
> checking whether struct tm is in sys/time.h or time.h... time.h
> checking for an ANSI C-conforming const... yes
> checking whether strerror_r is declared... yes
> checking for strerror_r... yes
> checking whether strerror_r returns char *... no
> checking for strtoul... yes
> checking for strtoll... yes
> checking for strlcat... yes
> checking for mbstowcs... yes
> checking for wcstombs... yes
> checking for mbrtoc16... no
> checking for c16rtomb... no
> checking for localtime_r... yes
> checking for strtok_r... yes
> checking for pthread_mutexattr_settype... yes
> checking that generated files are newer than configure... done
> configure: creating ./config.status
> config.status: creating Makefile
> config.status: creating test/Makefile
> config.status: creating config.h
> config.status: config.h is unchanged
> config.status: executing depfiles commands
> config.status: executing libtool commands
>
> $ make
> make  all-am
> make[1]: Entering directory '/Users/chg/.Trash/psqlodbc-12.00.0000 19.09.26'
> /bin/sh ./libtool  --tag=CC   --mode=compile gcc -DHAVE_CONFIG_H -I.   -I/usr/local/iODBC/include
-I/Users/chg/anaconda3/include-I/Users/chg/anaconda3/include/internal -DUNICODE_SUPPORT  -g -O2 -Wall -MT
psqlodbcw_la-info.lo-MD -MP -MF .deps/psqlodbcw_la-info.Tpo -c -o psqlodbcw_la-info.lo `test -f 'info.c' || echo
'./'`info.c
> libtool: compile:  gcc -DHAVE_CONFIG_H -I. -I/usr/local/iODBC/include -I/Users/chg/anaconda3/include
-I/Users/chg/anaconda3/include/internal-DUNICODE_SUPPORT -g -O2 -Wall -MT psqlodbcw_la-info.lo -MD -MP -MF
.deps/psqlodbcw_la-info.Tpo-c info.c  -fno-common -DPIC -o .libs/psqlodbcw_la-info.o
 
> In file included from info.c:19:
> In file included from ./psqlodbc.h:112:
> /usr/local/iODBC/include/sql.h:89:10: fatal error: 'iODBC/sqltypes.h' file not found
> #include <iODBC/sqltypes.h>

ISTM the above line in /usr/local/iODBC/include/sql.h should be

#include <sqltypes.h>

.

regards,
Hiroshi Inoue

>          ^~~~~~~~~~~~~~~~~~
> 1 error generated.
> make[1]: *** [Makefile:657: psqlodbcw_la-info.lo] Error 1
> make[1]: Leaving directory '/Users/chg/.Trash/psqlodbc-12.00.0000 19.09.26'
> make: *** [Makefile:479: all] Error 2
>
>
> I also tried with /usr/local/ for the path … the error then is  "./psqlodbc.h:136:10: fatal error: 'iodbcinst.h' file
notfound” instead.
 
>
> Since my experience with C(++) and compiling is pretty limited, I appreciate any help!
>
> Thanks,
> Christoph

-- 
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com