odbc not working in Rstudio-server ("Can't open lib"), but works in cli

[ospangler]

following the isql idea...

@cole

• terminal outside RStudio
• R session outside RStudio

Both of these work, no problem

@cole

terminal inside RStudio

No luck, with slightly different error:

[01000][unixODBC][Driver Manager]Can't open lib '/home/ec2-user/snowflake_odbc/lib/libSnowflake.so' : file not found
[ISQL]ERROR: Could not SQLConnect

@cole

R session inside RStudio (can even do system("isql") )

Also no luck, with system("isql -v snowflake... ") gives same [ISQL]ERROR: Could not SQLConnect

Is the idea that this has narrowed it down to R-studio Server's environment variables, since attemping with isql is independent of the odbc package?

I originally followed Snowflake's configuring-with-unixodbc doc , which mentions "By running unixodbc_setup.sh , you don’t need to set any environment variables."