[R] : RODBC and Sybase

[Detlef Steuer]

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