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

Igor Korot ikorot01 at gmail.com
Tue Aug 30 10:46:17 EDT 2016


Hi,

On Tue, Aug 30, 2016 at 12:53 AM, Manohar Reddy <manu.reddy52 at gmail.com> wrote:
> 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.

What did you try
>
>
>
> My environment details :
>
>
>
>     Os : windows 8
>
>     R version 3.3.1 (2016-06-21)
>
>
>
> Thanks in Advance .
>
> Manu.
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds


More information about the FreeTDS mailing list