Connecting to third-party-hosted database

[ma.gen...@gmail.com]

Hi,

In spark.rstudio.com, I was able to use FreeTDS driver to connect to a SQL Server on a third-party-hosted server. However, I am not able to do that with shinyapps.io . Is FreeTDS not supported? The following is the connection string that I've used successfully in spark:

'Driver=FreeTDS;TDS_Version=7.2;Server=<myserver>;port=1433;Database=<mydatabase>;UID=<myuserid>;Pwd=<mypassword>'

Thanks.

[Andy Kipp]

I believe this should be supported. What is the error message you are receiving?

-Andy

--
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/68b3f3cb-046d-4e92-b701-3383b82c3798%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[ma.gen...@gmail.com]

The error I am getting is: first argument is not an open RODBC channel

The same code works just fine on spark.

[ma.gen...@gmail.com]

Thank you Andy for fixing this! It is working now.

[Andy Kipp]

Hi,

You're welcome! I apologize, as I meant to follow up with you, yesterday. Yesterday's release of ShinyApps fixes the RODBC package so FreeTDS driver should now be supported.

Cheers

-Andy

To view this discussion on the web visit https://groups.google.com/d/msgid/shinyapps-users/d3947649-d3a8-49ae-bb5e-3d07ab85df0e%40googlegroups.com.