Unable to connect to MS SQL server from shinyapps.io From Windows using sqlOdbcDriver

Asked Mar 13 '17 at 13:36

Active Mar 13 '17 at 13:46

Viewed 173 times

I am unable to connect to MS SQL server from shinyapps.io From Windows using sqlOdbcDriver. This works perfectly in RStudio while running locally but when I tried to deploy in shiny server. I get the following error:

ERROR: first argument is not an open RODBC channel

Pls find the below code snippet:

con <- odbcDriverConnect("driver=SQL Server;database=<dbname>;server=<server name>;Uid=<uid>; Pwd=<pwd>")

Note : I am using Windows to run R.

Any help is highly appreciated. Thanks in advance

edited Mar 13 '17 at 13:46

Hong Ooi

56,353
13
134
187

asked Mar 13 '17 at 13:36

keeplearning

1

Does your SQL instance allow connections from random Internet addresses? Because that's what shinyapps.io is. – Hong Ooi Mar 13 '17 at 13:46
Thanks for the response. Could you pls let me know how i can check that? – keeplearning Mar 13 '17 at 13:48
Allow remote connections to this server option already selected. Still its the same issue – keeplearning Mar 13 '17 at 13:56

Unable to connect to MS SQL server from shinyapps.io From Windows using sqlOdbcDriver

0 Answers0