R help - Nov 2012 - Connect R with SQLSERVER

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.

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