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

[Prof Brian Ripley]

The original message was posted to this list twice on June 4. Mainly 
for the archives, see

https://stat.ethz.ch/pipermail/r-sig-mac/2009-June/006219.html

for three rounds of answers to the other posting.

On Sun, 7 Jun 2009, Don MacQueen wrote:

> 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
>
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
>

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595