Dirk, I did not realize libiodbc[1] is an alternative to unixODBC, how are you able to see this?
I also did not realize I had both of
them installed ...
Uninstalling libiodbc, keeping unixODBC,
adding the flag (I only suppose this is
how the flag is added), does nothing:
rasmus@iselin ~/src/RODBC % R CMD INSTALL RODBC --with-odbc-manager=odbc
Warning: unknown option ‘--with-odbc-manager=odbc’
* installing to library
‘/usr/home/rasmus/R/amd64-portbld-freebsd13.0-library/4.0’
* installing *source* package ‘RODBC’ ...
files ‘configure’, ‘configure.ac’ have the wrong MD5 checksums
** using staged installation
checking for gcc... cc
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 cc accepts -g... yes
checking for cc option to accept ISO C89... none needed
checking how to run the C preprocessor... cc -E
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -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 sql.h usability... yes
checking sql.h presence... yes
checking for sql.h... yes
checking sqlext.h usability... yes
checking sqlext.h presence... yes
checking for sqlext.h... yes
checking for library containing SQLTables... no
configure: error: "no ODBC driver manager found"
ERROR: configuration failed for package ‘RODBC’
* removing
‘/usr/home/rasmus/R/amd64-portbld-freebsd13.0-library/4.0/RODBC’
The other way around, uninstalling
unixODBC, keeping libiodbc, brings me
one step backwards:
rasmus@iselin ~/src/RODBC % R CMD INSTALL RODBC
--with-odbc-manager=iodbc
Warning: unknown option ‘--with-odbc-manager=iodbc’
* installing to library
‘/usr/home/rasmus/R/amd64-portbld-freebsd13.0-library/4.0’
* installing *source* package ‘RODBC’ ...
files ‘configure’, ‘configure.ac’ have the wrong MD5 checksums
** using staged installation
checking for gcc... cc
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 cc accepts -g... yes
checking for cc option to accept ISO C89... none needed
checking how to run the C preprocessor... cc -E
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -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 sql.h usability... no
checking sql.h presence... no
checking for sql.h... no
checking sqlext.h usability... no
checking sqlext.h presence... no
checking for sqlext.h... no
configure: error: "ODBC headers sql.h and sqlext.h not found"
ERROR: configuration failed for package ‘RODBC’
* removing
‘/usr/home/rasmus/R/amd64-portbld-freebsd13.0-library/4.0/RODBC’
... the sql.h and sqlext.h header files
are there, libiodbc provides them both:
root@iselin /usr/home/rasmus # pkg info -l libiodbc | egrep
'sql.h|sqlext.h'
/usr/local/include/libiodbc/isql.h
/usr/local/include/libiodbc/isqlext.h
/usr/local/include/libiodbc/sql.h
/usr/local/include/libiodbc/sqlext.h
... also when having unixodbc installed:
root@iselin /usr/home/rasmus # pkg info -l unixODBC-2.3.9 | egrep
'sql.h|sqlext.h'
/usr/local/include/sql.h
/usr/local/include/sqlext.h
Rasmus
[1] https://www.freshports.org/databases/libiodbc/
signature.asc
Description: PGP signature
______________________________________________ R-package-devel@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-package-devel
