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? Thanks in advance. Keith Hobbs MSc Student University of the West of England Bristol, UK
Getting R to call a stored procedure
2 messages · Keith Hobbs, Brian Ripley
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 at 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