Connecting R with MS SQL server 2005 - R-help

vikrant

Fri, Jan 15, 2010 1:53 AM #

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.

vikrant

Fri, Jan 15, 2010 2:23 AM #

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.

Dieter Menne

Fri, Jan 15, 2010 3:07 AM #

vikrant wrote:

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.

Uwe Ligges

Fri, Jan 15, 2010 3:15 AM #

On 15.01.2010 11:23, vikrant wrote:

See package RODBC.


Uwe Ligges