Setting up R to use the ODBC Driver

Introduction

R is a language and environment for statistical computing and graphics. It provides a wide variety of statistical and graphical techniques. More information on R is available at www.r-project.org.

The Actual Technologies OBDC drivers can be used by R 2.0 and later. In order to use an ODBC driver with R on Mac OS, the RODBC package must be re-built with the iODBC libraries on your Mac. In order to do this, you must have the Mac OS Developer Tools installed. The Developer Tools CD is provided by Apple with every new Macintosh and copy of Mac OS.

Download and Install RODBC

LIBS='-framework iODBC' PKG_CFLAGS='-I/Library/Frameworks/iODBC.framework/Headers' R CMD INSTALL RODBC_1.1-7.tar.gz

Load the RODBC Package

Test the Connection

If you see no error message, then you are connected. You can use the other RODBC package functions to fetch and update data in your database.