I am trying to establish a connection with an Informix database via my Shiny app. Whenever the server initializes and I navigate to the application, I receive this error:
[INFO] shiny-server - [/srv/shiny-server/app:55] global fileError: nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Can't open lib '/opt/IBM/Informix_Client-SDK/lib/cli/iclit09b.so' : file not found
I can verify that the file is in that location, however.
I am using a custom docker image from CentOS 7 with R version 4.1.1. This is because we cannot get the Informix ODBC driver installed on Ubuntu, so using the Rocker project image is out.
I am able to connect in an rterm and through Rscript, but not when running /usr/bin/shiny-server.
Any help would be appreciated.
Thank you.