[R-sig-DB] Getting R to call a stored procedure

Fri Dec 23 18:45:09 CET 2005

On Fri, 23 Dec 2005, Keith Hobbs wrote:

> Hi
>
> I'm trying to get R  (v 2.0.1) to call a stored procedure which is on
> a Microsoft SQL Server 2000 database. I've been looking through the
> documentation for the DBI package and presumed I'd need a specific
> driver for SQL Server. I've searched through Google but I can't find one.
>
> Does anyone know if there is a sql server driver, or one planned?
>
> Alternatively is there an ODBC driver that I can download?

Yes, in package RODBC.

-- 
Brian D. Ripley,                  ripley using stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595