R help - Jan 2010 - Connecting R with MS SQL server 2005

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?
-- 
View this message in context:
http://n4.nabble.com/Connecting-R-with-MS-SQL-server-2005-tp1014643p1014643.html
Sent from the R help mailing list archive at Nabble.com.

If anybody can provide me a link it will be very much helpful
-- 
View this message in context:
http://n4.nabble.com/Connecting-R-with-MS-SQL-server-2005-tp1014643p1014669.html
Sent from the R help mailing list archive at Nabble.com.

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.

On 15.01.2010 11:23, vikrant wrote:
>
>
> If anybody can provide me a link it will be very much helpful
See package RODBC.


Uwe Ligges