odbc and ShinyApps.io

Posit Professional & Hosted Products shinyapps.io
1

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!

2

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