Hi there,

I tried the command in https://stat.ethz.ch/**pipermail/r-help/2007-June/**
133606.html <https://stat.ethz.ch/pipermail/r-help/2007-June/133606.html>
In R, it works OK. In Rstudio, there seems to be a problem:


library(RODBC)ch <- odbcDriverConnect("Driver={Microsoft Access Driver
(*.mdb)}")Warning messages:1: In odbcDriverConnect("Driver={Microsoft
Access Driver (*.mdb)}") :
  [RODBC] ERROR: Could not SQLDriverConnect2: In
odbcDriverConnect("Driver={Microsoft Access Driver (*.mdb)}") :
  ODBC connection failed


I use R 2.15.3 and Rstudio 0.97.336. Did I miss anything?

Regards,
Aileen
On 15 April 2013 20:17, Prof Brian Ripley <ripley@stats.ox.ac.uk> wrote:

> On 15/04/2013 07:12, Aileen Lin wrote:
>
>> Hi there,
>>
>> I have seen this post.
>> https://stat.ethz.ch/**pipermail/r-help/2007-June/**133606.html<https://stat.ethz.ch/pipermail/r-help/2007-June/133606.html>
>>
>> have odbc installed in my machine. Now I have the following message:
>>
>>
>> channel2 <- odbcDriverConnect("test.mdb")**Warning messages:1: In
>>
>> odbcDriverConnect("test.mdb") :
>>    [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
>> Manager] Data source name not found and no default driver specified2:
>> In odbcDriverConnect("test.mdb") :
>>    [RODBC] ERROR: state 01S00, code 0, message [Microsoft][ODBC Driver
>> Manager] Invalid connection string attribute3: In
>>
>> odbcDriverConnect("test.mdb") : ODBC connection failed
>>
>>
>> Did I miss anything?
>>
>
> That is not doing what the URL you gave suggested.  Please do follow it.
>
>
> --
> Brian D. Ripley,                  ripley@stats.ox.ac.uk
> Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~**ripley/<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
>



-- 
Aileen L.

View my Linkedin profile: http://au.linkedin.com/in/aileen2

 Being happy doesn't mean you're perfect. It just means you've decided to
look beyond the imperfections- K.B Indiana (age
14)<http://www.boardofwisdom.com/default.asp?topic=1010&search=K%2EB+Indiana+%28age+14%29>

	[[alternative HTML version deleted]]

