r-dbi / odbc

Connect to ODBC databases (using the DBI interface)
https://odbc.r-dbi.org/
Other
387 stars 107 forks source link

GHA failure on macOS #794

Closed simonpcouch closed 4 months ago

simonpcouch commented 4 months ago

In the last day or two, we started seeing a new error on GHA for macOS (r-release):

* installing *source* package ‘odbc’ ...
** using staged installation
Found pkg-config cflags and libs!
PKG_CFLAGS=-I/opt/homebrew/opt/unixodbc/include
PKG_LIBS=-L/opt/homebrew/lib -lodbc
<stdin>:1:10: fatal error: 'sql.h' file not found
#include <sql.h>
         ^~~~~~~
1 error generated.
------------------------- ANTICONF ERROR ---------------------------
Configuration failed because odbc was not found. Try installing:
 * deb: unixodbc-dev (Debian, Ubuntu, etc)
 * rpm: unixODBC-devel (Fedora, CentOS, RHEL)
 * csw: unixodbc_dev (Solaris)
 * pacman: unixodbc (Archlinux, Manjaro, etc)
 * brew: unixodbc (Mac OSX)
To use a custom odbc set INCLUDE_DIR and LIB_DIR and PKG_LIBS manually via:
R CMD INSTALL --configure-vars='INCLUDE_DIR=... LIB_DIR=... PKG_LIBS=...'
--------------------------------------------------------------------
ERROR: configuration failed for package ‘odbc’

I first noticed this on #789, but re-ran the Actions on main this morning and saw new failures (see runs on e0a73b1 two days ago vs today).