[R] : RODBC and Sybase

[ripley@stats.ox.ac.uk]

Does any other source work?  I think RODBC needs to be updated to work
with 1.5.x (because of NA changes).


On Fri, 28 Jun 2002, Detlef Steuer wrote:

> Hello all!
>
> I´m trying to use the RODBC-0.8-3 package with Sybase 11.0.3.3 on Linux.
> R is R-1.5.1.
>
> My ODBC DSN seems to be configured. I can connect and work  using isql from
> unixODBC.
>
> Now, if I try
> library(RODBC)
> channel <- odbcConnect("SYBASE","user","pass")
>
> everything seems to work fine. (There is no error message, channel != 0)
>
> Nevertheless: all and every SQL statements return "No data", i.e.
>
> sqlQuery(channel, "use pubs2")
> [1] "No data"
>
> sqlQuery(channel, "select * from authors")
> [1] "No data"
>
> Does anybody have an idea where I could start to look for failure?
> Or better :-) : Any idea what is going on and what to do to get data out of
> Sybase?
>
> Thx a lot,
> detlef
>
> Detlef Steuer --- http://fawn.unibw-hamburg.de/steuer.html
>
> ***** Encrypted mail preferred *****
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> 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
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
>

-- 
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._