Re: How to connect Microsoft Sql server from R studio using freeTDS instead of RODBC package

Hi ,

Thanks for looking into my request,based on available information freeTDS
is also part of RODBC but in connection string we need to use driver name
as freeTDS instead of sql server ,i tried this way only but no luck.I'm
suspecting that the way that i did is not correct ,i may need to install
freeTDS separately and need to configure it on my machine.
    Attached is the screen shot for your reference,can you please help me
to how to install and how to configure it on my machine(i'm running with
windows 8).

Thanks in advance ..

Manu.


On Tue, Aug 30, 2016 at 8:21 PM, Igor Korot <[email protected]> wrote:

> Hi,
>
> On Tue, Aug 30, 2016 at 12:53 AM, Manohar Reddy <[email protected]>
> 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 and what doesn't work?
> Which freeTDS version do you have?
>
> Thank you.
>
> >
> >
> >
> > My environment details :
> >
> >
> >
> >     Os : windows 8
> >
> >     R version 3.3.1 (2016-06-21)
> >
> >
> >
> > Thanks in Advance .
> >
> > Manu.
> > _______________________________________________
> > FreeTDS mailing list
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 


Thanks,
Manohar Reddy P
+91-9705302062.

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds