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

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