From: Bill Szkotnicki <>
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
(519)824-4120 Ext 52253

______________________________________________ mailing list
PLEASE do read the posting guide
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 Please read the posting guide before posting to the list.