RODBC error with shiny apps

[Philip Moy]

I was able to deploy my app with shinyapps but I keep getting error: ERROR: first argument is not an open RODBC channel My app contains 3 files: ui.R server.R plots.R plots.R: library(RODBC) library(ggplot2) queryfunction <- function(channel) { myconn <- odbcConnect(dsn = "SQLServer") query = "my query" df <- sqlQuery(channel = myconn, query = query) odbcClose(myconn) return(df) } plotfunction <- function(channel) { a <- ggplot(queryfunction(channel), aes(x = Month, y = Volume)) + geom_bar(stat='identity') return(a) } server.R: library(shiny) source('plots.R') shinyServer(function(input, output,session) { #general volume, value, and table plots output$plot1 <- renderPlot({plotfunction(channel)}) }) This works perfectly fine on my own computer, but somehow on the server it doesn't. Does anyone know what the issue is?

[Tareef Kawaf]

Yes, unfortunately we don't have SQLServer drivers installed on the server so it isn't able to connect to your database.  

We currently only support open source databases on shinyapps.io, but we are watching to see if we get a lot more requests for proprietary databases.

--
You received this message because you are subscribed to the Google Groups "ShinyApps Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to shinyapps-use...@googlegroups.com.
To post to this group, send email to shinyap...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/shinyapps-users/45234b6a-e0d1-4d58-9ea8-2f67e4ecaf26%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Kai Ross]

I was trying to figure out the same issue, but for a Microsoft Access Database (.mdb).  So I would say count me as  +1 for requesting proprietary databases.

[Tareef Kawaf]

Hi Kai, 

Andy corrected me (while on vacation) and let me know that you can make this work by using the FreeTDS driver.  I am not an expert on this, but if you change your code to something like this:

odbcDriverConnect("driver=FreeTDS;Server=hostname;database=dbname;uid=username;pwd=password")

We don't have any DSNs configured, but you can see tips for how to do this here:

http://stackoverflow.com/questions/11084173/trying-to-connect-to-an-odbc-server-using-rodbc-in-ubuntu

-Tareef

On Fri, Oct 23, 2015 at 2:14 PM, Kai Ross <mailk...@gmail.com> wrote:

I was trying to figure out the same issue, but for a Microsoft Access Database (.mdb).  So I would say count me as  +1 for requesting proprietary databases.

--

You received this message because you are subscribed to the Google Groups "ShinyApps Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to shinyapps-use...@googlegroups.com.
To post to this group, send email to shinyap...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/shinyapps-users/7b7f5d59-3d00-4e51-9be2-b9245287af10%40googlegroups.com.

[Philip Moy]

Tareef, will this work if I am using Windows?

[Tareef Kawaf]

Unfortunately I don't think it will, I am not an expert, but I think you essentially have to have a different connection string based on whether this is running on Windows or on Ubuntu (Linux)

To view this discussion on the web visit https://groups.google.com/d/msgid/shinyapps-users/c13527eb-65c5-404e-87cf-3f1afca98e98%40googlegroups.com.

[Kai Ross]

Hi Tareef,

Thank you for getting back to me on this. Unfortunately I still haven't been able to get it to work.

I changed my code to:

conn=odbcDriverConnect("Driver=FreeTDS;Server=##.###.##.##;Database=/srv/connect/apps/My_app/My_data.mdb;Uid=;Pwd=;")

But get the error:

[RODBC] ERROR: state 08001, code 0, message [unixODBC][FreeTDS][SQL Server]Unable to connect to data source

When deployed to shinyapps.io. 

The link you provided shoes how they configured the odbcinst.ini file, but I don't think I have access to those directories by uploading a shiny app.

If you have any thoughts on what I'm doing incorrectly, or what other files I'd need to upload with my app to make things work, I'd be happy to hear them.

Thanks for your time,

-Kai

[Andy Kipp]

Kai,

Unfortunately, MS Access (MDB files) are not the same as MS SQL Server, and are not supported on shinyapps.io.

-Andy

To view this discussion on the web visit https://groups.google.com/d/msgid/shinyapps-users/570db8d8-2e59-4351-809b-b765397ca088%40googlegroups.com.

[Christopher Dailey]

I'm also interested in reading .accdb files from shinyapps.  The group I'm working with saves everything in an Access 2007 database and I'd like them to be able to upload the database file so I can run queries against it.  Having those drivers loaded onto the server would make it all work.  +1.

[Andy Kipp]

The problem here isn't really the fact that we don't load the drivers, its the fact that no driver exists that can read MSAccess files on any platform besides Windows (Shinyapp.io runs on Linux). 

--

You received this message because you are subscribed to the Google Groups "ShinyApps Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to shinyapps-use...@googlegroups.com.
To post to this group, send email to shinyap...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/shinyapps-users/20ca2020-32a4-4c19-9e19-83994f30be88%40googlegroups.com.

[Christopher Dailey]

Man, that's a bummer :/