Rれ
sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
sudo yum install tcl
sudo yum clean all
sudo yum install R
R-Stuio れ
wget http://download2.rstudio.org/rstudio-server-0.97.449-x86_64.rpm
sudo yum install --nogpgcheck rstudio-server-0.97.449-x86_64.rpm
ODBC れ
wget http://download.microsoft.com/download/B/C/D/BCDD264C-7517-4B7D-8159-C99FC5535680/RedHat6/msodbcsql-11.0.2270.0.tar.gz
tar -xzf msodbcsql-11.0.2270.0.tar.gz
cd msodbcsql-11.0.2270.0
れ 譯殊 れ企 --> ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.0.tar.gz
unixODBC れ 語ろ --> http://msdn.microsoft.com/ko-kr/library/hh568449.aspx --> unixODBC-2.3.0 覯朱...
./build_dm.sh --download-url=file://unixODBC-2.3.0.tar.gz
讓朱 蠍磯襴...
cd /tmp/unixODBC.19477.9801.16933/unixODBC-2.3.0
sudo make install
cd /home/dw_admin/msodbcsql-11.0.2270.0
sudo ./install.sh install
sudo odbcinst -q -d -n "ODBC Driver 11 for SQL Server"
sudo odbcinst -q -d -n "MSSQL36"
FreeTDS れ
sudo yum install freetds
sudo vi /etc/odbc.ini
[SQLSERVER_36]
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
Server=192.168.201.36,1433
ろ..
isql -v SQLSERVER_36 襦蠏語 れ
install.packages("RODBC")
library("RODBC")
conn <- odbcConnect("SQLSERVER_36",uid="reader", pwd="rd456$%^")
sqlQuery(conn, sql1)
wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm
wget http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
rpm -Uvh remi-release-6*.rpm epel-release-6*.rpm
yum install R
install.packages("gtools")
install.packages("gdata")
install.packages("caTools")
install.packages("gplots", pkgs="/home/dwa2007/gplots_2.11.0.1.tar.gz", repos = NULL)
install.packages("ROCR")