[R] New to R

Jeff Newmiller jdnewmil at dcn.davis.CA.us
Wed Jan 21 08:34:15 CET 2015


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:<jdnewmil at 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.Kristipati at 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 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.



More information about the R-help mailing list