[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