RODBC & Problems with Sybase Database

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

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