[R] Connect R with SQLSERVER

[Marc Schwartz]

On Nov 26, 2012, at 3:53 AM, R_Antony <antony.akkara at ge.com> wrote:

> Hi,
> Here im not able to connect with MS-SQLSERVER database with *.R-File. 
> 
> Previously i was able to do in R in different machine and configuration was
> R Ver-2.11.1
> Package Installed : RODBC_1.3-2
> 
> And now where im doinig now there the same code im trying to execute but its
> not connecting.
> configuration is,
> R Ver-2.12
> Package Installed : RODBC_1.3-2 - here iam trying to install (RODBC_1.3-6)
> which will support for R 2.12. But getting error while do installation.
> 
> ================================ERROR I
> GETTING======================================================
> C:\Documents and Settings\mduser>R CMD INSTALL "C:\Program
> Files\R\R-2.12.0\bin\
> RODBC_1.3-6.tar.gz"
> * installing to library 'C:/PROGRA~1/R/R-212~1.0/library'
> * installing *source* package 'RODBC' ...
> ** libs
> gcc -I"C:/PROGRA~1/R/R-212~1.0/include" -I.        -O3 -Wall  -std=gnu99 -c
> RODB
> C.c -o RODBC.o
> gcc: not found
> make: *** [RODBC.o] Error 127
> ERROR: compilation failed for package 'RODBC'
> * removing 'C:/PROGRA~1/R/R-212~1.0/library/RODBC'
> ======================================================================================
> 
> 
> - Could anyone please help me ?
> 
> Thanks
> Antony


First, DB related posts should go to R-SIG-DB:

 https://stat.ethz.ch/mailman/listinfo/r-sig-db

Please use that in the future, not R-Help.

Second, why are you trying to install the *source* version of RODBC when there are pre-compiled binary versions of the package available for Windows? 

Just use:

  install.packages("RODBC")

within an R session.

Finally, R version 2.12.0 is now over two years old. 2.15.2 is the current version, so you should also be updating your R installation.

Regards,

Marc Schwartz