topic Re: SAS/Access to snowflake Error in Administration and Deployment

SAS/Access to snowflake Error

RupaJ — Fri, 27 Oct 2023 15:37:39 GMT

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

Re: SAS/Access to snowflake Error

Morse_Bill — Fri, 27 Oct 2023 15:48:36 GMT

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

perhaps you export there ??

Re: SAS/Access to snowflake Error

RupaJ — Fri, 27 Oct 2023 16:03:47 GMT

This is what I have in sasenv_local

ODBCSYSINI=/etc/odbc.ini
export ODBCSYSINI

Re: SAS/Access to snowflake Error

SASKiwi — Sun, 29 Oct 2023 21:37:44 GMT

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