[R] : RODBC and Sybase

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

From: Detlef Steuer (Detlef.Steuer@unibw-hamburg.de)
Date: Fri 28 Jun 2002 - 22:28:05 EST 

Message-id: <XFMail.20020628142805.steuer@unibw-hamburg.de>

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

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