** testing if installed package can be loadedĪll the installer does is test that the library loads. Then manually compile and install RODBC (you need the full path to the downloaded file for it to work): $ R CMD INSTALL /Users/Hiltmon/Downloads/RODBC_1.Īfter a pile of configure and compile messages, you should see: ** R 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |