How to connect Microsoft Sql server from R studio using freeTDS instead of RODBC package
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.