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:<jdnew...@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....@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 <rip...@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, rip...@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
>>
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
