[R] RODBC & Problems with Sybase Database

Christian Schulz c.schulz at metrinomics.de
Thu May 30 10:31:01 CEST 2002


Hello,
i  would like import Data from Sybase DataBase to R-1.5.0 via RODBC.

With this i get a connection without problems !
channel <- odbcConnect("ODBCName","LoginName","LoginPass")
    
dataSybase  <-  sqlFetch(channel,"EPORT_XYZ")
,but when i try this i get a message error ?  
(Perhaps the _ is a problem, i know that's i.e. not usual to name 
objects with _ in R ?)

Error in odbcFetchRows(channel, max = max, transposing = (as != 
"matrix"),  :  negative length vectors are not allowed


......i don't know what's happen because the ODBC Import works
i.e. with Excel/SPSS  fine !

Thanks for advance & regards,
Christian








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