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

[Don MacQueen]

There are others better at ODBC than I. None the less...

I think you have to set up a DSN on the Mac side that points to the 
Windows OS, just like for any remote host.  There should be a GUI app 
in your Utilities folder for specifying ODBC drivers and creating 
DSNs.

I don't know what ODBC driver you should use, but a bit of web 
searching will no doubt find some companies that will sell you one. 
Or maybe Microsoft includes one with Office for Mac, or maybe 
Microsoft has one you can download.

My ODBC configuration file is
   ~/Library/ODBC/odbc.ini

-Don

At 9:26 PM +0900 6/4/09, publicgeneral at mac.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?
>
>Appreciate the help.
>
>Regards,
>David
>
>_______________________________________________
>R-SIG-Mac mailing list
>R-SIG-Mac at stat.math.ethz.ch
>https:// stat.ethz.ch/mailman/listinfo/r-sig-mac


-- 
---------------------------------
Don MacQueen
Lawrence Livermore National Laboratory
Livermore, CA, USA
925-423-1062
macq at llnl.gov