search for: odbcfetchrows

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

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

Sorry, I was commenting on the previous windows version (version file says 0.5a) (the first one which ran under RW.1.0.0) I have Win NT 4.0 Service pack 5 and R is > version _ platform Windows arch x86 os Win32 system x86, Win32 status major 1 minor 0.0 year 2000 month February day 29 language R > -----Original Message----- > From: Prof Brian

Hi Michael, Here is the result of my first testing: (0) Dr. Watson Sorry, I should have given a more precise description: by default in R exists a function with the name 'table', if you use this name as in odbcPrimaryKeys(0, table) a Dr. Watson occurs, because table does not give a table name. However, it is always a good idea to prevent Dr. Watsons, even if it is triggered by a

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