Search code examples
roracle-databaserodbc

Connecting to Oracle Database from R?

I have searched and it seems that RODBC or Roracle are used to connect to a oracle database within R.

However, both of these packages will not install for me in R 3.1.1....am I missing something? Is there a new/latest package that just came out that I should be using instead?

package ‘RODBC’ is available as a source package but not as a binary

Warning in install.packages : package ‘RODBC’ is not available (for R version 3.1.1)

I am using Mac OSX 10.9.4. I tried using install.packages('RODBC').

Solution

  • I get that message when i use 3.1.1 so I toggled to 3.1.0 using R studio.

    When I am using R 3.1.0 i get the message 

    Warning message:
package ‘RODBC’ was built under R version 3.1.2

    The package does get installed and i am able to use the functions in the package just fine.