On Thu, Jun 4, 2009 at 9:22 AM, David Marra <publicgene...@me.com> wrote:
> Simon, > > Is there an R driver for MS SQL Server? > You were on the right track. Use RODBC for MS SQL Server. Sean > > On Jun 4, 2009, at 10:17 PM, Simon Urbanek wrote: > > David, >> >> On Jun 4, 2009, at 8:40 , David Marra wrote: >> >> Everyone, >>> >>> I would like to access from R running in OS X 10.5 a Microsoft SQL >>> database that is running in Windows on a Parallels virtual machine. >>> >>> The Parallels VM and the OS X are on the same Mac. >>> >> >> Technically, that's irrelevant, because they act as two separate computers >> - for all practical purposes you're connecting a Mac to a database on >> another PC over a network. >> >> >> A DSN is set up on Windows. Running queries on the VM itself with the >>> Windows version of R using the RODBC package commands odbcConnect and >>> sqlQuery works just fine. >>> >>> Does anyone know how this can be done? How to make R in OS X aware of the >>> Windows DSN? What ODBC driver works for OS X to get access to the Windows >>> VM? >>> >>> >> You'll need an ODBC driver for OS X capable of using Microsoft SQL. It's >> been a while since I used one (if I recall correctly it was the Actual one), >> but here are some links: >> >> http://www.actualtechnologies.com/product_sqlserver.php >> http://uda.openlinksw.com/odbc/express/odbc-sqlserver-ee/ >> >> Once the driver is installed, you can use ODBC Administrator utility to >> create a DSN on the Mac. (However, I have never really used ODBC in R since >> there are native R drivers for all databases I'm using ...). >> >> Cheers, >> Simon >> >> > _______________________________________________ > R-SIG-Mac mailing list > R-SIG-Mac@stat.math.ethz.ch > https://stat.ethz.ch/mailman/listinfo/r-sig-mac > [[alternative HTML version deleted]] _______________________________________________ R-SIG-Mac mailing list R-SIG-Mac@stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-mac