在centos系统中使用R,连接mysql时,需要RODBC包,直接安装时出现各种错误,
提示no zero exit
少了mysql.h头文件等,原因是没有安装UnixODBC驱动及ioDBC驱动,
用yum安装之后即可。
1. 安装unixODBC
http://m.blog.csdn.net/blog/allens_zhou/8575400
2. 安装iodbc
sudo yum install iodbc
3. 进入R,安装RODBC
> install.packages("RODBC")
Installing package into ‘/home/keylab/R/x86_64-redhat-linux-gnu-library/3.1’
(as ‘lib’ is unspecified)
--- Please select a CRAN mirror for use in this session ---
CRAN mirror
1: 0-Cloud 2: Algeria
3: Argentina (La Plata) 4: Australia (Canberra)
5: Australia (Melbourne) 6: Austria
7: Belgium 8: Brazil (BA)
9: Brazil (PR) 10: Brazil (RJ)
11: Brazil (SP 1) 12: Brazil (SP 2)
13: Canada (BC) 14: Canada (NS)
15: Canada (ON) 16: Canada (QC 1)
17: Canada (QC 2) 18: Chile
19: China (Beijing 1) 20: China (Beijing 2)
21: China (Beijing 3) 22: China (Beijing 4)
23: China (Hefei) 24: China (Lanzhou)
25: China (Xiamen) 26: Colombia (Cali)
27: Czech Republic 28: Denmark