Thanks for your follow up.
Sorry, that UID specified twice was a typo. I have odbc.ini file as what you have attached with the email.
SnowflakeDSIIDriver points to the snowflake driver that is mentioned in this documentation:
Here is what the file looks like:
I enabled logging in the /etc/odbcinst.ini file path as I could not find any files in the location that you mentioned and here is what my error says:
root@ip-10-251-4-55:/usr/bin# isql -v snowflake-precision-med-user
[unixODBC][Driver Manager]Can't open lib '/usr/lib/snowflake/odbc/lib/libSnowflake.so' : file not found
[ISQL]ERROR: Could not SQLConnect
I double checked and the driver is available there in that file location. These were the files available in /usr/lib/snowflake/odbc/ path:
libSnowflake.so libSnowflake.so.save simba.snowflake.ini
The symlink is also not broken. I am thinking somehow the driver is corrupted?
I was just wondering what would be the best way to debug and fix this problem? I was thinking of fixing with this driver than trying the Rstudio pro driver with simba odbc data connector.
Can I reinstall the driver without purging the old driver? Or if there is a way to check if my driver has some issue and do some broken fix?
I found the Simba connector documentation little confusing to understand. I didn't know where to obtain the tarball name and follow that process .