[R] : RODBC and Sybase

Detlef Steuer Detlef.Steuer at unibw-hamburg.de
Fri Jun 28 14:28:05 CEST 2002

Hello all!

IŽm trying to use the RODBC-0.8-3 package with Sybase on Linux.
R is R-1.5.1.

My ODBC DSN seems to be configured. I can connect and work  using isql from

Now, if I try 
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

Thx a lot,

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

More information about the R-help mailing list