Thanks 

Regards,

Lalitha K.

Associate Software Engineer

917411291011

________________________________________
From: Jeff Newmiller <jdnew...@dcn.davis.ca.us>
Sent: 21 January 2015 21:34
To: Lalitha Kristipati; R-help@r-project.org
Subject: Re: [R] New to R

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.



============================================================================================================================
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.
============================================================================================================================

______________________________________________
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.

Reply via email to