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

Manohar Reddy manu.reddy52 at gmail.com
Wed Aug 31 11:59:56 EDT 2016


Hi,

  My  MS sql server and R environment running on my local machine and the
respective port was opened, from this link (http://www.freetds.org/
userguide/osissues.htm.) i didn't get much information ,can you please help
out  me is there any way that can i download it and configured it on
widnows 8.

Thanks,Manu.

On Wed, Aug 31, 2016 at 6:59 PM, Frediano Ziglio <freddy77 at gmail.com> wrote:

> Hi,
>   I don't know Shiny however if I understood:
> - you have a R application running inside this cloud;
> - the application should use RODBC to connect to some SQL Server
> database using ODBC.
> Now I know ODBC. ODBC mainly use drivers (dynamic modules) to connect
> to different database types. As you said that Shiny run on Linux you
> need a driver for Linux that is able to connect to SQL Server, FreeTDS
> is one of them! However the "SQL Server"/"FreeTDS" string after the
> "Driver=" in the connection string is not just a simple string, it's a
> reference to an installed driver. So you have to install the driver
> and configure in the DM (Driver Manager, the ODBC library that RODBC
> is linked to) installed in the Shiny cloud machine. Here we can't help
> much unless you have some direct/standard access (like ssh) to this
> machine.
> About the connection. Where do the SQL Server is running? Inside the
> cloud? On your machine? Is your machine connected and opened (firewall
> speaking) to this Shiny cloud machine(s) ?
> Are you trying to install FreeTDS also on your machine where you are
> testing how your R application is running (I don't know R environment)
> ?
> To install FreeTDS on Windows you can see
> http://www.freetds.org/userguide/osissues.htm.
>
> Frediano
>
>
> 2016-08-31 13:30 GMT+01:00 Manohar Reddy <manu.reddy52 at gmail.com>:
> > 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 <ikorot01 at gmail.com> wrote:
> >
> >> Hi,
> >>
> >> On Wed, Aug 31, 2016 at 2:38 AM, Manohar Reddy <manu.reddy52 at gmail.com>
> >> 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 <freddy77 at gmail.com>
> >> 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 <manu.reddy52 at gmail.com>:
> >> >> > 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
> >> >>
> >> >
> >> >
> >> >
> >> > --
> >> >
> >> >
> >> > Thanks,
> >> > Manohar Reddy P
> >> > +91-9705302062.
> >> > _______________________________________________
> >> > 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.
> > _______________________________________________
> > 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.


More information about the FreeTDS mailing list