Re: [R] : RODBC and Sybase

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

From: ripley@stats.ox.ac.uk
Date: Fri 28 Jun 2002 - 22:47:42 EST 

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

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

-- 
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 : Wed 16 Oct 2002 - 11:57:34 EST