[R] Connecting R with MS SQL server 2005

Dieter Menne dieter.menne at menne-biomed.de
Fri Jan 15 12:07:04 CET 2010




vikrant wrote:
> 
> Is it possible to connect R with Ms SQL Server 2005 ? If Yes how to
> connect it and can you please provide some tutorial for it?
> 

It's easiest using RODBC. Using Control Panel/Administrator/Data Sources
(Free translation from German, might be slightly off), create a source using
the SQL Server Native Client; you might have to install that client from the
MS site, if it is not there.

Then, connect to that source and issue a SELECT...

Dieter


-- 
View this message in context: http://n4.nabble.com/Connecting-R-with-MS-SQL-server-2005-tp1014643p1014705.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list