This is not really a question about R... it is a question about databases
because similar divisions occur in every imperative programming language that
deals with databases. ODBC is a software layer that aims to create a uniform
API for the programmer among different variations of SQL databases (though it
doesn't entirely succeed). RODBC gives R access to that API. You have to use
OS-specific utilities outside of R to link ODBC Data Source Names to specific
ODBC-to-DB "drivers".
The alternatives are usually much more specific to the DB back end, with
potential ability to take advantage of DB- specific features, and disadvantages
of being more closely tied to that particular software.
There is a mailing list (R-sig-db) where you should ask more specific questions
about how R deals with these non-R- specific APIs, but each of the R packages
maps to much more extensive documentation about those APIs that you will need
to be familiar with in order to make progress with them.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
On January 20, 2015 9:51:44 PM PST, Lalitha Kristipati
<lalitha.kristip...@techmahindra.com> wrote:
>Hi,
>
>I am trying to connect R to databases.
>
>I found two ways to connect.
>
>1.By using specific package (eg RMySQL to connect to R)
>
>2.By using connectors and RODBC package.
>
>can any one tell me the difference between those two methods.
>
>
>
>Regards,
>
>Lalitha K.
>
>Associate Software Engineer
>
>917411291011
>
>
>============================================================================================================================
>Disclaimer: This message and the information contained herein is
>proprietary and confidential and subject to the Tech Mahindra policy
>statement, you may review the policy at
>http://www.techmahindra.com/Disclaimer.html externally
>http://tim.techmahindra.com/tim/disclaimer.html internally within
>TechMahindra.
>============================================================================================================================
>
>
> [[alternative HTML version deleted]]
>
>______________________________________________
>R-help@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.
______________________________________________
R-help@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.
