"sql.h" and "sqlext.h" not found during install on MacOS about r-exasol HOT 9 CLOSED

Hi @markheckmann,

I can't say it for sure, but I have an idea what it could be. It is possible, that you are missing the development package for unixodbc, it has probably a name similar to unixodbc-dev or unixodbc-devel. This package usually contains the missing header files.

from r-exasol.

I saw that the dev lib is required on linux, but was not able to find one for MacOS on brew (neither unixodbc-dev or unixodbc-devel are available).

Hence, I installed unixODBC again from source as described here. After that, the exasol R package can be installed succesfully 🚀🚀🚀

However, now a new problem arises: A lib is not found, though the path seems correct. 💀💀💀

> con <- exasol::dbConnect(drv="exa", dsn="EXASolution Driver", uid="xxx", pwd="xxx")  
...
1: In odbcDriverConnect(con_str) :
  [RODBC] ERROR: state 01000, code 0, message [unixODBC][Driver Manager]Can't open lib '/Users/markheckmann/Library/ODBC/EXASolution ODBC.bundle/Contents/MacOS/libexaodbc-io418sys.dylib' : file not found
...

However, the file exists:

markheckmann~$ls "/Users/markheckmann/Library/ODBC/EXASolution ODBC.bundle/Contents/MacOS" | grep libexaodbc-io418sys.dylib
libexaodbc-io418sys.dylib

Any ideas?

from r-exasol.

Hi @markheckmann ,

Good to here, that you could solve the header issue. Maybe the header files are not included in newer brew packages.

Regarding your new issue. I see one thing, that might cause an issue. Your path contains a space, this is often a cause for such issues. However, this is only a guess.

Another thing you could check is the permissions of the file with:

ls -l /Users/markheckmann/Library/ODBC/EXASolution ODBC.bundle/Contents/MacOS/libexaodbc-io352fw.dylib

from r-exasol.

Hi @markheckmann,

Do you further help, or can I close this issue?

from r-exasol.

I have not solved it yet. Also, I am currently on vacation. I would be glad if the issue could remain open for 2 more weeks until I can get back to it. Thanks! :)

from r-exasol.

I will leave it open, until you are back.

from r-exasol.

Hello @markheckmann,

Any updates on this topic, or can we close this ticket?

from r-exasol.

@tkilias ; I have the same issue using a docker container rocker/rstudio arm64 (Ubuntu) with the latest Exasol Driver (EXASOL_ODBC-7.1.22):

Error in odbcGetInfo(con) : argument is not an open RODBC channel
In addition: Warning messages:
1: In odbcDriverConnect(con_str) :
[RODBC] ERROR: state 01000, code 0, message [unixODBC][Driver Manager]Can't open lib 'EXASolution Driver' : file not found
2: In odbcDriverConnect(con_str) : ODBC connection failed

running

DBI::dbConnect(
  "exa",
  exahost    = "xxx",
  uid        = "xxx",
  pwd        = "xxx",
  encryption = "Y"
)

Error in odbcGetInfo(con) : argument is not an open RODBC channel
In addition: Warning messages:
1: In odbcDriverConnect(con_str) :
[RODBC] ERROR: state 01000, code 0, message [unixODBC][Driver Manager]Can't open lib '/EXASolution_ODBC-7.1.22/lib/linux/x86_64/libexaodbc-uo2214lv2.so' : file not found
2: In odbcDriverConnect(con_str) : ODBC connection failed

running

DBI::dbConnect(drv = "exa", dsn ="exasolution-uo2214lv2_64", encryption = "Y")

Permissions seems to be correct:

ls -l /EXASolution_ODBC-7.1.22/lib/darwin/x86_64/libexaodbc-io352fw.dylib

-rwxr-xr-x 1 10448 users 507380 Jul 22 06:53 /EXASolution_ODBC-7.1.22/lib/darwin/x86_64/libexaodbc-io352fw.dylib

I would appreciate your help!

from r-exasol.

@Majid-Eismann this looks like a different issue, can you open an issue and copy your issue there?

from r-exasol.