Re: [R] RODBC

From: Bill Szkotnicki <bszk_at_uoguelph.ca>
Date: Tue, 29 May 2007 09:20:37 -0400

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

______________________________________________
R-help_at_stat.math.ethz.ch 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.
Received on Tue 29 May 2007 - 13:45:09 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 29 May 2007 - 14:31:53 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.