Can't connect to Snowflake via unixODBC and R

Asked Apr 14 '22 at 16:20

Active Apr 15 '22 at 08:06

Viewed 33 times

I'm trying to connect to a Snowflake database via R and unixODBC but keep getting the error below, and for the life of me I can't figure out how to move forward.

[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed

I installed unixODBC and the Snowflake ODBC driver on my M1 Mac (I think this might be part of the problem?) as per Snowflake's documentation and running the command odbcinst -j in a terminal gives the expected output.

However, if I try to run isql -v <DSN> in a terminal to test the connection, I get the error above. I get the same error if I try to connect via R with the odbc package, or via RStudio.

Any help would be greatly appreciated!

EDIT: I have tried the solution from the question here, with no success. I've also seen this solution but that involves installing the x86_64 version of R, RStudio, and the ODBC driver, which also didn't work.

edited Apr 15 '22 at 08:06

asked Apr 14 '22 at 16:20

Flobagob

Please refer another similar post - https://stackoverflow.com/questions/69652761/error-loading-snowflake-odbc-driver-on-mac-m1-from-erlang-call-odbc-connect – Pankaj Apr 14 '22 at 16:23
If you look a few links into that link, you'll find https://stackoverflow.com/a/71790445/3358272, where the author claims to have snowflake odbc working on mac's M1. – r2evans Apr 14 '22 at 20:27
I have tried both of these solutions, and neither works. – Flobagob Apr 15 '22 at 08:03
Has this issue been resolved? – Srinath Menon Apr 19 '22 at 04:46
@SrinathMenon - nope, not yet. – Flobagob Apr 19 '22 at 05:55

Can't connect to Snowflake via unixODBC and R

0 Answers0