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:
odbcDriverConnect("Driver=FreeTDS;TDS_Version=7.4;Server=tcp:xxx.windows.net,1433;Port=1433;Database=xxx;Uid=xxx;Pwd=xxx;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;")
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!