odbc and ShinyApps.io

Hello!

I have this line of code which works locally on my machine:

dbconnect <<- dbConnect(odbc(),Driver="ODBC Driver 13 for SQL Server",Server="XXX",Database="XXX",uid="XXX",pwd="XXX")

(The XXX's are filled in and the server is hosted on azure, nothing local.

When I run it on ShinyApps.io I get this error:

Warning: Error in : nanodbc/nanodbc.cpp:983: 00000: [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 13 for SQL Server' : file not found

Any idea why?

(Also, side note: what is the best way of entering the server address and password since this app will be public?)

Thanks!

That specific driver is not available at Shinyapp.io, RStudio profesional drivers (which are available at Shinyapp.io) have different names, look at the documentation