[R-SIG-Mac] Query MS SQL Server DB using RODBC from OS X

[David Marra]

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?

Appreciate the help.

Regards,
David