I have confirmed this is working if I'm running R through terminal on Amazon Linux 2 vm. I went ahead and installed rstudio-server (rstudio-server-rhel-1.2.5033-x86_64.rpm) on the same ec2, but cannot get the connection to work. It sounds similar (but the opposite problem) to this question .
> myconn <- DBI::dbConnect(odbc::odbc(), "snowflake", uid="...", pwd='...')
Error: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib '/home/ec2-user/snowflake_odbc/lib/libSnowflake.so' : file not found
I've slogged through this with zero system/linux admin experience and have little idea of how to proceed. My only ideas are to try the RODBC package instead, or venture into the world of "setting paths" or "symlinked" or environment variables.
Since I can successfully connect through R in the terminal is there any sort of command I could try (at r-terminal) to gather more info on what the issue is? Why would it work through r-terminal, but not rstudio-server?
Since I'm using rstudio-server while signed in as an "user" I thought it was a permissions issue. I've changed permissions to /home/ec2-user/snowflake_odbc/lib/libSnowflake.so, still with no luck.
I've tried odbc::odbcListDrivers() from both r-terminal and rstudio-server and they return the exact same results.
Configured to specific port following: https://support.rstudio.com/hc/en-us/articles/200552316-Configuring-the-Server