Re: [R] RODBC finding dsn information using OpenLink iODBC drivers

About this list Date view Thread view Subject view Author view Attachment view

From: Prof Brian Ripley (ripley@stats.ox.ac.uk)
Date: Sat 12 Jan 2002 - 05:44:15 EST 

Message-id: <Pine.LNX.4.31.0201111841240.27248-100000@gannet.stats>

On Fri, 11 Jan 2002, Andrew Schuh wrote:

> I'm using RODBC to connect to a MS SQL server. I've been able to get it
> to work without much of a hitch in windows. However, I'm using
> OpenLink's iODBC drivers on the Linux side and I'm not sure how RODBC is
> able to find information about the dsn's (which is in the odbc.ini
> file?). I've tested the connection with the test program included by
> OpenLink and I've verified that it connects to the server correctly. I
> just need to get R to be able to connect.

It's a while since I tested iODBC. It's the driver manager that reads the
odbc.ini file, not the R interface. Michael Lapsley has some examples in
the README file which I believe worked.

I usually use unixODBC, which seemed when I last looked to be more
powerful.

> I believe I am using the latest RODBC package and R>1.3.1 on a Redhat
> 7.2 (Intel) machine. 

-- 
Brian D. Ripley,                  ripley@stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request@stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

About this list Date view Thread view Subject view Author view Attachment view

This archive was generated by hypermail 2.1.3 : Thu 17 Jan 2002 - 11:10:11 EST