Hello, I am trying to connect my shiny app to my Azure SQL server using RODBC, but I keep running into errors. For testing I have configured my SQL Server to not block any IP addresses.
My connection string is:
I have been trying several different versions of FreeTDS. However, every time I deploy my app I receive the following errors:
ERROR: state 08001, code 0, message [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
ERROR: state 01000, code 20013, message [unixODBC][FreeTDS][SQL Server]Unknown host machine name.
I have not been able to find any resolution online, has anyone successfully deployed an app to shinyapps that connects to Azure SQL who could share their code? Much appreciated, thanks!