Hello,
I recently installed the SAS/ACCESS to Snowflake connector on my SAS 9.4 M7 environment on Linux. However, when I try a libname it throws an error. I exported the odbc.ini, odbcinst.ini and simba.snowflake.ini. I was able to test the Snowflake odbc driver outside of SAS and it works successfully. I have all the snowflake odbc driver files under /opt/snowflake_odbc/lib.
pwd
/opt/snowflake_odbc/lib
export ODBCINI=/etc/odbc.ini
export ODBCINST=/etc/odbcinst.ini
export SIMBAINI=/opt/snowflake_odbc/lib/simba.snowflake.ini
Tried to run SAS from command line -- /opt/sas/sashome/SASFoundation/9.4/sas -nodms -WORK /SAS_Work/Misc_WS
NOTE: SAS initialization used:
real time 0.05 seconds
cpu time 0.02 seconds
LIBNAME SNWFLK snow server=abc.com database=snowdb schema=snowschema user=abcd password=pwd;
ERROR: Could not load /opt/sas/sashome/SASFoundation/9.4/sasexe/sassnf (36
images loaded)
ERROR: libSnowflake.so: cannot open shared object file: No such file or
directory
ERROR: The SAS/ACCESS Interface to SNOWFLAKE cannot be loaded. The SASSNF
code appendage could not be loaded.
ERROR: Error in the LIBNAME statement.
How can I go about troubleshooting this?
... View more
