<html>
<head>
</head>
<body>
Jason,<br>
many thanks for this suggestion, but if try<br>
<br>
dataSybase <- sqlFetch(channel,"DATA.EXPORT_Name")<br>
<br>
i get the same error message:<br>
<br>
Error in odbcFetchRows(channel, max = max, transposing = (as != "matrix"),
: <br>
negative length vectors are not allowed<br>
<br>
and when i try dataSybase <small><small><- </small></small>sqlFetch(channel,DATA.EXPORT_NAME)<br>
<br>
i get the not surprinsing message error <br>
<br>
Error in sqlFetch(channel, DATA.EXPORT <- NAME) : <br>
<- should be a name<br>
<br>
Curious is, when i export the tables from Sybase Database to MySql Database<br>
and use then (only via RODBC - not RMySql):<br>
tabs <small><-</small> sqlFetch(channel,"DATA.EXPORT_Name")
it works fine !<br>
<br>
A test ( Notice - same tables only with the difference i importing the
Sybase data without any modifications to MySql ):<br>
sqlTables(channel.Sybase)<br>
Error in odbcFetchRows(channel, max = max, transposing = (as != "matrix"),
: <br>
negative length vectors are not allowed<br>
<br>
sqlTables(channel.MySql)<br>
works fine !<br>
<br>
P.S. I get the feeling that the Sybase Anywhere Odbc driver is not the best
and the problem is not RODBC ;-)<br>
<br>
thanks for suggestions and regards,Christian<br>
<br>
<br>
<br>
<br>
Jason Turner wrote:<br>
<blockquote type="cite" cite="mid:20020531071632.A4358@camille.indigoindustrial.co.nz">
<pre wrap="">On Thu, May 30, 2002 at 02:10:55PM +0200, Christian Schulz wrote:<br></pre>
<blockquote type="cite">
<pre wrap="">I follow the recommendation from Prof. Ripley and change the sqlFetch <br>function, but<br>the error message is the same.<br>My problem is (1.) that the name of the tables in th db have all the <br>name structure DATA.EXPORT_NAME <br>and i understand that .EXPORT_NAME cause the problems.<br></pre>
</blockquote>
<pre wrap=""><!----><br>Actually, the *unquoted* symbol _ causes problems. For compatiblity<br>reasons with old S, _ is the same as <-. I believe they (R-core) are <br>considering removing this nasty bit of syntax.<br><br>In the meantime, consider this:<br>+++<br>## this line is the same as foo <- some <- 1<br></pre>
<blockquote type="cite">
<pre wrap="">foo <- some_1<br>ls()<br></pre>
</blockquote>
<pre wrap=""><!---->[1] "foo" "some" <br></pre>
<blockquote type="cite">
<pre wrap="">foo<br></pre>
</blockquote>
<pre wrap=""><!---->[1] 1<br></pre>
<blockquote type="cite">
<pre wrap="">some<br></pre>
</blockquote>
<pre wrap=""><!---->[1] 1<br>## with quotes, however, it does what you'd expect if you <br>## didn't know about _<br></pre>
<blockquote type="cite">
<pre wrap="">bar <- "some_1"<br>bar<br></pre>
</blockquote>
<pre wrap=""><!---->[1] "some_1"<br>+++<br><br>So, you can still have _ , as long as you wrap quotes around it. This<br>will cause problems if your table or coulumn names have quotes in them, <br>but that would be very unusual.<br><br>Cheers<br><br>Jason<br></pre>
</blockquote>
<br>
</body>
</html>