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