[R] create an access file

[Jeff Newmiller]

You missed that this is not the RStudio support forum.

You probably also missed that R comes in both 32-bit and 64-bit flavors in the Windows binary distribution, and you have to use the one that matches the ODBC drivers you want to use. You can specify which version RStudio is to use.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

Aileen Lin <aileenshanhong.lin at gmail.com> wrote:

>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 at 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 at 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
>>