Displaying 5 results from an estimated 5 matches for "c_rodbcfetchrow".
Did you mean:
c_rodbcfetchrows
2012 Jul 30
1
why querying Sybase IQ using RODBC returns error ?
...han))
if (length(list(...)) > 0)
sql <- sprintf(sql, ...)
x <- sqlQuery(chan, sql, as.is = as.is)
return(x)
}
R>
R>
R>
R> x <- sybaseiq.query("select * from syagprd1.orders where
tradedate='120727' and acct='DVW'")
Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max, buffsize,
:
negative length vectors are not allowed
R> x
[1] "42000 -131 [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'order' on
line 1"
[2] "[RODBC] ERROR:...
2010 Jan 24
0
Setting the value of max in calls to sqlGetResults
...ersion of R (R 2.9.2) and the
corresponding unix ODBC 64 bit package
When issuing a SqlQuery, I get the following error
> library(RODBC)
> channel <- odbcConnect("OraLSH", <user>, <password>)
> sqlQuery(channel,"select sysdate from dual")
Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,
buffsize, :
negative length vectors are not allowed
> close(channel)
> q()
I know I can replace the call to sqlQuery with calls to its component
functions odbcQuery and sqlGetResults to get the same result (and the same
error)
> library(RO...
2010 Jan 24
0
Setting thevalue of max in calls to sqlGetResults
...ersion of R (R 2.9.2) and the
corresponding unix ODBC 64 bit package
When issuing a SqlQuery, I get the following error
> library(RODBC)
> channel <- odbcConnect("OraLSH", <user>, <password>)
> sqlQuery(channel,"select sysdate from dual")
Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,
buffsize, :
negative length vectors are not allowed
> close(channel)
> q()
I know I can replace the call to sqlQuery with calls to its component
functions odbcQuery and sqlGetResults to get the same result (and the same
error)
> library(RO...
2012 Jul 04
1
RODBC tables
Dear Sir/Madam,
I am desperately in need of some help. I am trying to access tables from
the oracle database and inserting them into R via a data frame and I keep
getting an error saying that "Error in .Call(C_RODBCFetchRows,
attr(channel, "handle_ptr"), max, buffsize, :
negative length vectors are not allowed".
My connection is fine and my code for this is:
check<-odbcConnect(dsn="********",uid="*********",pwd="******")
There are terms instead of the *'s but I...
2009 Dec 19
2
Run time error when executing sqlQuery using the 64-bit version of R with 64-bit RODBC package in a Solaris 10 Sparc machine.
...unix ODBC 64 bit package
The red highlighted text below is the error I'm getting trying to when
invoking a sqlQuery
> library(RODBC)
> channel <- odbcConnect("OraLSH", <user>, <password>)
> sqlQuery(channel,"select sysdate from dual")
Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max,
buffsize, :
negative length vectors are not allowed
> close(channel)
> q()
Any suggestions are greatly appreciated.
Alexander Chelminsky
Principal
CSC
GBS | p: +1 781 290 1620 | f: +1 781 890 1208 | m: +1 617 650 5453 |
achelminsky at csc.co...