Im using Azure to run an R Shiny app via docker.
R querys an Azure Sql DB using FreeTDS driver.
Shiny app successfully appears locally.
Im able to run the shiny app within the docker container locally.
However when I pull the image from dockerhub to an azure webapp I have the error
Error: nanodbc/nanodbc.cpp:1021: 00000: [FreeTDS][SQL Server]Unable to connect to data source [FreeTDS][SQL Server]Adaptive Server connection failed
When I look at the odbc drivers the path looks wrong.
They look local to the user rather than local to the image.
Can anyone confirm a successfull install of odbc driver within a docker image?