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

Hi ,



  Just I want to clarify my requirement before seeking someone help on my
issue.



 *Requirement* :



    I need to develop the webpage/Report using shinypackages then I need to
host it on shinyapps.io (shinyapps.io hosted on *Linux*)for that I’m using
RODBC package to connect my MS Sql server ,but when I deployed it on
shinyapps.io ,I have encountered this (first argument is not an open RODBC
channel) error, based on this error message I googled and found that I need
to use freeTDS drivers instead of sql server and I have cheeked with “R
professional help”  and they guide me like I  don’t need to install freeTDS
separately  just I need to use freeTDS drivers instead of sql server but I
couldn’t able to make a successful connection. I’m suspecting that I may
need to install freeTDS and need to configure it on my machine which has
been running with Windows 8.



*Help* :



  Now I’m seeking a help like how to install freeTDS and how to configure
it on windows 8 ,so that I can make a successful connection to my MS Sql
server from R studio/Shinyapps.io


  FYI… https://groups.google.com/forum/#!topic/shinyapps-users/hs4bQHsk9JU



Thanks,Manu.

On Wed, Aug 31, 2016 at 5:25 PM, Igor Korot <[email protected]> wrote:

> Hi,
>
> On Wed, Aug 31, 2016 at 2:38 AM, Manohar Reddy <[email protected]>
> wrote:
> > Hi ,
> >
> >   As per your suggestion i have made changes and ran it ,still i'm
> getting
> > same error message,can you please guide me how to install freeTDS and how
> > to configure it on windows 8 ,may be i will make a successful connection
> > once if i have done with these changes.
>
> You didn't answer Frediano' questions:
>
> Where did you get the freeTDS driver?
> How did you compile and install it?
>
> And one more:
> What happen if you try the Microsoft ODBC driver? It should be
> installed by default
> If not just go to microsoft.com and grab one.
>
> Thank you.
>
> >
> > Thanks in advance..
> >
> > Manohar.
> >
> > On Wed, Aug 31, 2016 at 2:20 AM, Frediano Ziglio <[email protected]>
> wrote:
> >
> >> Hi,
> >>   some considerations:
> >> - TDS_Version 9.0 was never implemented, see
> >> http://www.freetds.org/userguide/choosingtdsprotocol.htm;
> >> - the "Data source name not found and no default driver specified" in
> >> this case means that the driver ("FreeTDS") is not installed
> >> correctly. It could mean that you install the wrong bit version or
> >> that you don't install it correctly. Where did you download/how do you
> >> compile and install? Does it happen also with "SQL Server" driver?
> >> - the "\n" before "Database" is an error, there should be no such
> >> character before "Database" option;
> >> - the "first argument is not an open RODBC channel" just indicate that
> >> connection before failed;
> >> - there are some not implemented option in the connection string, see
> >> http://www.freetds.org/userguide/odbcconnattr.htm.
> >>
> >> Frediano
> >>
> >>
> >> 2016-08-30 16:55 GMT+01:00 Manohar Reddy <[email protected]>:
> >> > 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
> >>
> >
> >
> >
> > --
> >
> >
> > Thanks,
> > Manohar Reddy P
> > +91-9705302062.
> > _______________________________________________
> > 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