...
I have a Shiny app hosted on Posit Connect and connected to an Azure SQL Server database. The app "works" for a little bit and then once a swarm of users tries to access it the entire app becomes disconnected from the server. When I check the Posit Logs I get this error message basically all over the log:
Warning: Error in eval: nanodbc/nanodbc.cpp:4616: 00000: [Microsoft][ODBC Driver 17 for SQL Server]Communication link failure
The app works just fine locally. I do not see any coding errors in the logs, just the communication link failure. Has anyone dealt with this before?