[R] RODBC

[Bill Szkotnicki]

I have now read the README file which I should have done before. :-[   
Sorry.
To summarize:
- Install the odbc connector driver (3.51)
- Set up the dsn in the file   .odbc.ini
- It works beautifully and RODBC is super!


Prof Brian Ripley wrote:
> yOn Mon, 28 May 2007, Bill Szkotnicki wrote:
>
>> Hello,
>>
>> I have installed R2.5.0 from sources ( x86_64 )
>> and added the package RODBC
>> and now I am trying to connect to a mysql database
>> In windows R after installing the 3.51 driver
>> and creating the dsn by specifying server, user, and password
>> it is easy to connect with
>> channel <- odbcConnect("dsn")
>>
>> Does anyone know what needs to be done to make this work from linux?
>
> Did you not read the RODBC README file?  It is described in some detail
> with reference to tutorials.
>

-- 
Bill Szkotnicki
Department of Animal and Poultry Science
University of Guelph
bszk at uoguelph.ca
(519)824-4120 Ext 52253