This tells the compiler to use the unixODBC ODBC libraries installed by Homebrew in /usr/local/lib and not the iODBC ones installed by Apple in /usr/lib. To compile and install it properly, first do: $ DYLD_LIBRARY_PATH=/usr/local/lib The goal here is to link RODBC with the installed unixODBC library to make it work.ĭownload the source code of RODBC from CRAN RODBC and choose the package source link (refers to the 1.3-8 version). If you have already done this, remove.packages('RODBC') in R to get rid of it.

packages.install('RODBC'), you will get a version compiled with the non-working iODBC libraries. Warning: If you install RODBC the usual way, i.e.

Test the connection using isql $ isql -v database1Īnd you should see +-+ You could also set the connection in ~/.odbc.ini but I find system level connections work better, especially when moving code into production. Download the latest driver file from the postgres file browser and then (only commands shown): $ tar zxvf Įstablish the driver in /usr/local/etc/odbcinst.ini: ĭescription = PostgreSQL ODBC driver (Unicode 9.2)Īnd set up a connection in /usr/local/etc/odbc.ini: The best way to install this is to download and compile it manually. This turns out to be easy, just use Homebrew: $ brew update The database (in my case PostgreSQL, with developer libraries, so that the compiles will work.RStudio (optional, but so much better than the standard R GUI).Xcode with command line tools installed (needed to compile the ODBC drivers and RODBC).It is assumed you have the following installed and running: So here’s how to set up R with unixODBC on OS X to access a PostgreSQL database. And two, even if you do install the ODBC Administrator tool and configure iODBC, it does not work with unicode drivers and databases. One, it uses the iODBC libraries that come with OS X and these do not work out of the box. The data is in a PostgreSQL database, so we use the RODBC package to access the database from R.īut this does not work under Macintosh OS X. ~Hilton.Īt work, we use R to analyze data and calculate risk. Use the RPostgresSQL package that connects directly using the C drivers, its a lot faster to set up and run. Hi Folks, Please do not follow this advice, its an old article that somehow has stayed way past its welcome in the search engines.

Odbc administrator tool for mac os x