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

Manohar Reddy manu.reddy52 at gmail.com
Tue Aug 30 11:55:33 EDT 2016


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 <ikorot01 at gmail.com> wrote:

> 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 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
> > FreeTDS at lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 


Thanks,
Manohar Reddy P
+91-9705302062.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FreeTDS_Error_message.PNG
Type: image/png
Size: 37135 bytes
Desc: not available
URL: <http://lists.ibiblio.org/pipermail/freetds/attachments/20160830/92d9cbf0/attachment-0001.png>


More information about the FreeTDS mailing list