Manohar Reddy
2016-Aug-29 17:26 UTC
[R] How to connect Microsoft Sql server from R studio using freeTDS instead of RODBC package
Hi Mark,
Thank you so much for reply, using exiting ODBC drivers I will make a
connection to sql server and it?s working fine in my local, but as per
shinyapps.io I need to use freeTDS drivers instead RODBC ,so that I may not
encounter the any issue .For me here challenging work is how to install
freeTDS on my machine and how to configure it?
Is there any drivers/way that can i make a connection to sql server
and I shouldn?t encounter the issue after deploying application on
shinyapps.io.
Thanks,Manu.
On Mon, Aug 29, 2016 at 9:35 PM, Mark Sharp <msharp at txbiomed.org>
wrote:
> Manu,
>
> Read the first paragraph under section "1 ODBC Concepts" of
> https://cran.r-project.org/web/packages/RODBC/vignettes/RODBC.pdf. This
> describes the relationship among the various parts of the technical stack
> that allows connectivity to the database system via ODBC. One of the points
> made is that RODBC uses an ODBC driver (e.g., Actual Technologies, Easysoft
> and OpenLink).
>
> I use the driver from Actual Technologies on Mac OS, but many others have
> used freeTDS. I had trouble with freeTDS years ago and decided my time was
> worth the minor cost of using the commercial product from Actual
> Technologies.
>
> The driver you use is computer OS specific while RODBC is not.
>
> It is also convenient to use an ODBC manager, which is typically a
> graphical application used to create and manage the configuration files
> used by the ODBC driver.
>
> Mark
>
> R. Mark Sharp, Ph.D.
> Director of Primate Records Database
> Southwest National Primate Research Center
> Texas Biomedical Research Institute
> P.O. Box 760549
> San Antonio, TX 78245-0549
> Telephone: (210)258-9476
> e-mail: msharp at TxBiomed.org
>
> > On Aug 28, 2016, at 11:53 PM, 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.
> >
> >
> >
> > My environment details :
> >
> >
> >
> > Os : windows 8
> >
> > R version 3.3.1 (2016-06-21)
> >
> >
> >
> > Thanks in Advance .
> >
> > Manu.
> >
> > [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide http://www.R-project.org/
> posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
>
>
>
>
>
>
>
> CONFIDENTIALITY NOTICE: This e-mail and any files and/or attachments
> transmitted, may contain privileged and confidential information and is
> intended solely for the exclusive use of the individual or entity to whom
> it is addressed. If you are not the intended recipient, you are hereby
> notified that any review, dissemination, distribution or copying of this
> e-mail and/or attachments is strictly prohibited. If you have received this
> e-mail in error, please immediately notify the sender stating that this
> transmission was misdirected; return the e-mail to sender; destroy all
> paper copies and delete all electronic copies from your system without
> disclosing its contents.
>
--
Thanks,
Manohar Reddy P
+91-9705302062.
[[alternative HTML version deleted]]
Mark Sharp
2016-Aug-29 19:23 UTC
[R] How to connect Microsoft Sql server from R studio using freeTDS instead of RODBC package
Manu,
I believe you are mistaken regarding using freeTDS instead of RODBC.
shinyapps.io apparently has freeTDS drivers already installed. I am guessing
that either you have not configured your connections string
(odbcDriverConnect("driver = FreeTDS; ...")) correctly or your
database server has a firewall rule that is not allowing a connection from
shinyapps.io.
However, please note, I have not used shinyapps.io and am making these guesses
based on my experience with RODBC and the documentation I have read. You will
want to find someone with shinyapps.io experience.
Mark
R. Mark Sharp, Ph.D.
Director of Primate Records Database
Southwest National Primate Research Center
Texas Biomedical Research Institute
P.O. Box 760549
San Antonio, TX 78245-0549
Telephone: (210)258-9476
e-mail: msharp at TxBiomed.org
On Aug 29, 2016, at 12:26 PM, Manohar Reddy <manu.reddy52 at gmail.com>
wrote:>
> Hi Mark,
>
>
> Thank you so much for reply, using exiting ODBC drivers I will make a
connection to sql server and it?s working fine in my local, but as per
shinyapps.io I need to use freeTDS drivers instead RODBC ,so that I may not
encounter the any issue .For me here challenging work is how to install freeTDS
on my machine and how to configure it?
>
>
> Is there any drivers/way that can i make a connection to sql server
and I shouldn?t encounter the issue after deploying application on shinyapps.io.
>
>
> Thanks,Manu.
>
>
> On Mon, Aug 29, 2016 at 9:35 PM, Mark Sharp <msharp at txbiomed.org>
wrote:
> Manu,
>
> Read the first paragraph under section "1 ODBC Concepts" of
https://cran.r-project.org/web/packages/RODBC/vignettes/RODBC.pdf. This
describes the relationship among the various parts of the technical stack that
allows connectivity to the database system via ODBC. One of the points made is
that RODBC uses an ODBC driver (e.g., Actual Technologies, Easysoft and
OpenLink).
>
> I use the driver from Actual Technologies on Mac OS, but many others have
used freeTDS. I had trouble with freeTDS years ago and decided my time was worth
the minor cost of using the commercial product from Actual Technologies.
>
> The driver you use is computer OS specific while RODBC is not.
>
> It is also convenient to use an ODBC manager, which is typically a
graphical application used to create and manage the configuration files used by
the ODBC driver.
>
> Mark
>
> R. Mark Sharp, Ph.D.
> Director of Primate Records Database
> Southwest National Primate Research Center
> Texas Biomedical Research Institute
> P.O. Box 760549
> San Antonio, TX 78245-0549
> Telephone: (210)258-9476
> e-mail: msharp at TxBiomed.org
>
> > On Aug 28, 2016, at 11:53 PM, 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.
> >
> >
> >
> > My environment details :
> >
> >
> >
> > Os : windows 8
> >
> > R version 3.3.1 (2016-06-21)
> >
> >
> >
> > Thanks in Advance .
> >
> > Manu.
> >
> > [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
>
>
>
>
>
>
>
> CONFIDENTIALITY NOTICE: This e-mail and any files and/or attachments
transmitted, may contain privileged and confidential information and is intended
solely for the exclusive use of the individual or entity to whom it is
addressed. If you are not the intended recipient, you are hereby notified that
any review, dissemination, distribution or copying of this e-mail and/or
attachments is strictly prohibited. If you have received this e-mail in error,
please immediately notify the sender stating that this transmission was
misdirected; return the e-mail to sender; destroy all paper copies and delete
all electronic copies from your system without disclosing its contents.
>
>
>
> --
>
>
> Thanks,
> Manohar Reddy P
> +91-9705302062.
CONFIDENTIALITY NOTICE: This e-mail and any files and/or attachments
transmitted, may contain privileged and confidential information and is intended
solely for the exclusive use of the individual or entity to whom it is
addressed. If you are not the intended recipient, you are hereby notified that
any review, dissemination, distribution or copying of this e-mail and/or
attachments is strictly prohibited. If you have received this e-mail in error,
please immediately notify the sender stating that this transmission was
misdirected; return the e-mail to sender; destroy all paper copies and delete
all electronic copies from your system without disclosing its contents.
Manohar Reddy
2016-Aug-30 12:05 UTC
[R] How to connect Microsoft Sql server from R studio using freeTDS instead of RODBC package
Hi Mark, Thanks,as per your suggestion and based on below link, I?m trying to connect my remote server but while connecting I have encountered attached error, can you please look in that and help out me. Link : https://groups.google.com/forum/#!topic/shinyapps-users/hs4bQHsk9JU Note : 1. I tired without freeTDS versions also though nolock 2. We have set it my remote sql server like by default it will allow all the connections. Thnaks,Manu. On Tue, Aug 30, 2016 at 12:53 AM, Mark Sharp <msharp at txbiomed.org> wrote:> Manu, > > I believe you are mistaken regarding using freeTDS instead of RODBC. > shinyapps.io apparently has freeTDS drivers already installed. I am > guessing that either you have not configured your connections string > (odbcDriverConnect("driver = FreeTDS; ...")) correctly or your database > server has a firewall rule that is not allowing a connection from > shinyapps.io. > > However, please note, I have not used shinyapps.io and am making these > guesses based on my experience with RODBC and the documentation I have > read. You will want to find someone with shinyapps.io experience. > > Mark > > R. Mark Sharp, Ph.D. > Director of Primate Records Database > Southwest National Primate Research Center > Texas Biomedical Research Institute > P.O. Box 760549 > San Antonio, TX 78245-0549 > Telephone: (210)258-9476 > e-mail: msharp at TxBiomed.org > > On Aug 29, 2016, at 12:26 PM, Manohar Reddy <manu.reddy52 at gmail.com> > wrote: > > > > Hi Mark, > > > > > > Thank you so much for reply, using exiting ODBC drivers I will make a > connection to sql server and it?s working fine in my local, but as per > shinyapps.io I need to use freeTDS drivers instead RODBC ,so that I may > not encounter the any issue .For me here challenging work is how to install > freeTDS on my machine and how to configure it? > > > > > > Is there any drivers/way that can i make a connection to sql > server and I shouldn?t encounter the issue after deploying application on > shinyapps.io. > > > > > > Thanks,Manu. > > > > > > On Mon, Aug 29, 2016 at 9:35 PM, Mark Sharp <msharp at txbiomed.org> wrote: > > Manu, > > > > Read the first paragraph under section "1 ODBC Concepts" of > https://cran.r-project.org/web/packages/RODBC/vignettes/RODBC.pdf. This > describes the relationship among the various parts of the technical stack > that allows connectivity to the database system via ODBC. One of the points > made is that RODBC uses an ODBC driver (e.g., Actual Technologies, Easysoft > and OpenLink). > > > > I use the driver from Actual Technologies on Mac OS, but many others > have used freeTDS. I had trouble with freeTDS years ago and decided my time > was worth the minor cost of using the commercial product from Actual > Technologies. > > > > The driver you use is computer OS specific while RODBC is not. > > > > It is also convenient to use an ODBC manager, which is typically a > graphical application used to create and manage the configuration files > used by the ODBC driver. > > > > Mark > > > > R. Mark Sharp, Ph.D. > > Director of Primate Records Database > > Southwest National Primate Research Center > > Texas Biomedical Research Institute > > P.O. Box 760549 > > San Antonio, TX 78245-0549 > > Telephone: (210)258-9476 > > e-mail: msharp at TxBiomed.org > > > > > On Aug 28, 2016, at 11:53 PM, 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. > > > > > > > > > > > > My environment details : > > > > > > > > > > > > Os : windows 8 > > > > > > R version 3.3.1 (2016-06-21) > > > > > > > > > > > > Thanks in Advance . > > > > > > Manu. > > > > > > [[alternative HTML version deleted]] > > > > > > ______________________________________________ > > > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > > > https://stat.ethz.ch/mailman/listinfo/r-help > > > PLEASE do read the posting guide http://www.R-project.org/ > posting-guide.html > > > and provide commented, minimal, self-contained, reproducible code. > > > > > > > > > > > > > > > > CONFIDENTIALITY NOTICE: This e-mail and any files and/or attachments > transmitted, may contain privileged and confidential information and is > intended solely for the exclusive use of the individual or entity to whom > it is addressed. If you are not the intended recipient, you are hereby > notified that any review, dissemination, distribution or copying of this > e-mail and/or attachments is strictly prohibited. If you have received this > e-mail in error, please immediately notify the sender stating that this > transmission was misdirected; return the e-mail to sender; destroy all > paper copies and delete all electronic copies from your system without > disclosing its contents. > > > > > > > > -- > > > > > > Thanks, > > Manohar Reddy P > > +91-9705302062. > > CONFIDENTIALITY NOTICE: This e-mail and any files and/or attachments > transmitted, may contain privileged and confidential information and is > intended solely for the exclusive use of the individual or entity to whom > it is addressed. If you are not the intended recipient, you are hereby > notified that any review, dissemination, distribution or copying of this > e-mail and/or attachments is strictly prohibited. If you have received this > e-mail in error, please immediately notify the sender stating that this > transmission was misdirected; return the e-mail to sender; destroy all > paper copies and delete all electronic copies from your system without > disclosing its contents. >-- 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: <https://stat.ethz.ch/pipermail/r-help/attachments/20160830/d9e84096/attachment.png>