R help - May 2002 - RODBC & Problems with Sybase Database

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

On Thu, 30 May 2002, Christian Schulz wrote:
> 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 ?)
It is. Search the archives for a workaround I posted a few days ago.

-- 
Brian D. Ripley,                  ripley at 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 at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

Jason,
many thanks for this suggestion, but if try

dataSybase  <-  sqlFetch(channel,"DATA.EXPORT_Name")

i get the same error message:

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

and when i try  dataSybase <-  sqlFetch(channel,DATA.EXPORT_NAME)

i get the not surprinsing message error

Error in sqlFetch(channel, DATA.EXPORT <- NAME) :
        <- should be a name

Curious is, when i export the tables from Sybase Database to MySql Database
and  use then (only via RODBC - not RMySql):
      tabs <-   sqlFetch(channel,"DATA.EXPORT_Name")    it works
fine !

A test ( Notice - same tables only with the difference i  importing  the 
Sybase data without any modifications to MySql ):
sqlTables(channel.Sybase)
Error in odbcFetchRows(channel, max = max, transposing = (as != 
"matrix"),  :
        negative length vectors are not allowed

sqlTables(channel.MySql)
works fine  !

P.S. I get the feeling that the Sybase Anywhere Odbc driver is not the 
best and the problem is not RODBC  ;-)

thanks for suggestions and regards,Christian




Jason Turner wrote:
>On Thu, May 30, 2002 at 02:10:55PM +0200, Christian Schulz wrote:
>
>>I follow the recommendation from Prof. Ripley and change the sqlFetch 
>>function, but
>>the error message is the same.
>>My problem is (1.)  that the name of the tables in th db have all the 
>>name structure  DATA.EXPORT_NAME 
>>and i understand that  .EXPORT_NAME cause the problems.
>>
>
>Actually, the *unquoted* symbol _ causes problems.  For compatiblity
>reasons with old S, _ is the same as <-.  I believe they (R-core) are 
>considering removing this nasty bit of syntax.
>
>In the meantime, consider this:
>+++
>## this line is the same as foo <- some <- 1
>
>>foo <- some_1
>>ls()
>>
>[1] "foo"     "some"   
>
>>foo
>>
>[1] 1
>
>>some
>>
>[1] 1
>## with quotes, however, it does what you'd expect if you 
>## didn't know about _
>
>>bar <- "some_1"
>>bar
>>
>[1] "some_1"
>+++
>
>So, you can still have _ , as long as you wrap quotes around it.  This
>will cause problems if your table or coulumn names have quotes in them, 
>but that would be very unusual.
>
>Cheers
>
>Jason
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
https://stat.ethz.ch/pipermail/r-help/attachments/20020531/575e4361/attachment.html