R help - Jan 2002 - RODBC finding dsn information using OpenLink iODBC drivers

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.

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

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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 at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

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 at 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 at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._