On Thu, Jun 4, 2009 at 8:40 AM, David Marra <publicgeneral@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]]

