SAS/Access to snowflake Error

[RupaJ]

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?

[Morse_Bill]

what's in  %SASROOT%/SASFoundation/9.4/bin/sasenv_local  ?

perhaps you export there ??

[RupaJ]

This is what I have in sasenv_local 

ODBCSYSINI=/etc/odbc.ini
export ODBCSYSINI

[SASKiwi]

I suggest you open a track with SAS Tech if you haven't already to diagnose this further. It looks like there is either an installation or configuration problem happening. 

EDIT: Have you set the  LD_LIBRARY_PATH environment variable as explained in the SAS configuration documentation?

Link: https://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf