Skip to Content.
Sympa Menu

freetds - [freetds] How to connect Microsoft Sql server from R studio using freeTDS instead of RODBC package

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Manohar Reddy <manu.reddy52 AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] How to connect Microsoft Sql server from R studio using freeTDS instead of RODBC package
  • Date: Tue, 30 Aug 2016 10:23:03 +0530

Hi,



Can anyone guide me how to connect the Microsoft Sql server 2012/14 from
R studio using freeTDS package instead of RODBC ,I can able to connect the
MS Sql server from R studio using RODBC.

Actually my requirement is I have developed webpage/report using Shiny
package then I was deployed it on Shinyapps.io ,but after deploying I’m
encountering error like “”ERROR:*first argument is not an open RODBC
channel*” ,based on this error message I did searched in google and found
that we need to use freeTDS drivers instead of RODBC but I found some
articles regarding freeTDS but it’s not useful for me.



I was eagerly waiting for solution from someone since last month, but not
yet and this issue is not allowing me to further .Can anyone please help me
out me(how to install freeTDS and how to configure it) on same.



My environment details :



Os : windows 8

R version 3.3.1 (2016-06-21)



Thanks in Advance .

Manu.




Archive powered by MHonArc 2.6.24.

Top of Page