search for: odbcfetchrow

Dear R Gurus, I would very much appreciate some help with this code snippit from my RODBC package. R crashes or exhibits bizarre behaviour when repeatedly fetching large numbers of rows. Examples: > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx > odbcFetchRows(0,max=50000)->xx 3rd arg (table) not of type VECSXP, from R_HashGet Segmentation fault (core dumped) > odbcFetchRows(0,max=100000)-&gt...

...2003-12-15 00:00:00 3 2003-12-15 00:00:00 4 2003-12-15 00:00:00 5 2003-12-15 00:00:00 6 2003-12-15 00:00:00 7 2003-12-15 00:00:00 8 2003-12-15 00:00:00 9 2003-12-15 00:00:00 ??Which is the mistake?. And the second question is the command odbcFechRows() don't work, for example if write tbl<-odbcFetchRows(canal) in place of sqlFetch result a error stat = -1 and the list is NULL odbcGetErrMsg return No results available. Thank Ruben

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

Hello everyone! I'm having the dreaded repeated rows problem in RODBC. Specifically, when I have a NULL value in a column, odbcFetchRows reads the value not as NULL or NA but as the most recent non-NULL value in the column. If there is no such non-NULL column, odbcFetchRows reads the value as 0. Let me give you an example (though you won't be able to run it with the "product" table--just use some table you've defi...

...Subject: Re: [R] RODBC > > X-Keywords: > > > > Dammit! Sorry, folks, to make such stupid mistakes. > > New version on my 'web page'. > > > > On Tue, Mar 07, 2000 at 08:37:14PM -0300, David Middleton wrote: > > > i) a typo in sqlgetresults "odbcFetchrow" should be > "odbcFetchRow" at > > > line 420 of RODBC/R/RODBC (binary dist. from Brian Ripley) > > > line 356 of RODBC/R/sql.R (your source dist) > > > > > > ii) the C source change to RODBCNumRows does not set num[0] in the > > &gt...

...y is this? If it is generally possible, that some ODBC drivers do not support Row count, then we need to check odbcGetErrMsg() after each of those functions, which are expected to return a data.frame. Or better those functions have to check on their own and to build up the COMPLETE data frame using odbcFetchRow() until all rows are fetched. Of course this should not be R-code but C-code, as looping in R is not a good idea. (2) in sqlSave() if (any(sqlTables(0)[3] == tablename)) { probably should read if (any(sqlTables(channel)[3] == tablename)) { furthermore if sqlTables() fails with "[ROD...

.... However, when trying to retrieve a result set in repeated batches the first batch returns results ok, but then subsequent calls return no data (see code below). I tried setting believeNRows=FALSE both in odbcConnect() and in sqlGetResults() but this doesn't appear to make any difference. Also odbcFetchRows() suffers the same problem. The documentation states "sqlGetResults is a mid-level function. It should be called after a call to odbcQuery and used to retrieve waiting results into a data frame. Its main use is with max set to non zero it will retrieve the result set in batches with repeated...