On Thu, Jun 4, 2009 at 8:40 AM, David Marra <publicgene...@me.com> 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. 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?
>
The VM is a remote host, as far as OS X is concerned. I think, then, that
you will need to set up ODBC on OS X to connect to the remote host.
Sean
[[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
