On Thu, Jun 4, 2009 at 9:22 AM, David Marra <publicgeneral@me.com> wrote:

> Simon,
>
> Is there an R driver for MS SQL Server?
>

You were on the right track.  Use RODBC for MS SQL Server.

Sean


>
> On Jun 4, 2009, at 10:17 PM, Simon Urbanek wrote:
>
>  David,
>>
>> On Jun 4, 2009, at 8:40 , David Marra 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.
>>>
>>
>> Technically, that's irrelevant, because they act as two separate computers
>> - for all practical purposes you're connecting a Mac to a database on
>> another PC over a network.
>>
>>
>>  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?
>>>
>>>
>> You'll need an ODBC driver for OS X capable of using Microsoft SQL. It's
>> been a while since I used one (if I recall correctly it was the Actual one),
>> but here are some links:
>>
>> http://www.actualtechnologies.com/product_sqlserver.php
>> http://uda.openlinksw.com/odbc/express/odbc-sqlserver-ee/
>>
>> Once the driver is installed, you can use ODBC Administrator utility to
>> create a DSN on the Mac. (However, I have never really used ODBC in R since
>> there are native R drivers for all databases I'm using ...).
>>
>> Cheers,
>> Simon
>>
>>
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac@stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
>

	[[alternative HTML version deleted]]

