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 -- View this message in context: http://r.789695.n4.nabble.com/Connect-R-with-SQLSERVER-tp4650822.html Sent from the R help mailing list archive at Nabble.com.
Connect R with SQLSERVER
2 messages · R_Antony, 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