Hi Team,
I know the reason why i am getting the error below. However, I need your input to make it work.
I have used below code to connect to my sql server
conn_pr <- odbcDriverConnect(connection = paste0("Driver={SQL Server};server=AAAAA;database=master;UID=AAAAA_AAAAA;PWD=AAAAA_BBBB!;trusted_connection = yes;"))
The above connection works while hosting my application locally. But when I host on shinyapps.io, the connection fails.
Is there a way to connect to sql server post hosting on shinyapps.io?