Sean,
I am new to ODBC. How can ODBC be set up on OS X?
On Jun 4, 2009, at 10:16 PM, Sean Davis wrote:
>
>
> 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
