similar to: RODBC

Dear lists, It seems that RODBC has a problem : when reading through ODBC from an Access table with missing values, *character* missing values are (correctly) reported as NA factor values. *Numeric* values, however, retain the value of the same variable in the previous row. My setup : R 1.1.1 under Win95, RODBC as compiled with the R Win CRAN distribution, MS Access 97. I just discovered this,

Dear lists, It seems that RODBC has a problem : when reading through ODBC from an Access table with missing values, *character* missing values are (correctly) reported as NA factor values. *Numeric* values, however, retain the value of the same variable in the previous row. My setup : R 1.1.1 under Win95, RODBC as compiled with the R Win CRAN distribution, MS Access 97. I just discovered this,

Full_Name: Emmanuel Charpentier Version: R 1.1.1 OS: Windows 98 FE / Linux (Debian 2.2) Submission from: (NULL) (164.2.255.244) This bug report is pro forma. I've already reported it informally on R-help and R-devel. The current (0.7) version of RODBC has a problem with missing values. It correctly gets missing "character" values (as blanks), but puts the last non-missing value of

Dear List, I recently asked about any R implementations of Whitehead's methods for sequential clinical trials. Here's the summary of answers so far : 1) There is no R public implementation of those methods 2) There exists an interest for such a package, which does things quite different from Lan-deMets paradigm (shortly : Whitehead's methods allows for unplanned interim analyses

Dear List, I would like to know if there exist some R implementation of John Whitehead's procedures for the planning and analysis of group sequential clinical trials. His book is enlightenig but somewhat frustrating : it has a good basic exposition of his framework, but the technical details are sparse, and leave much work to do when one plans to reuimplement part of the procedures. For

Dear list, Working the example in Stats complements to V&R 3rd ed., I found this : > library(MASS) > library(mva) > data(farms) > plot(mca(farms,abbrev=TRUE),cex=rep(0.7,2)) # ... Works OK # Sheer curiosity ... > plot(mca(farms,abbrev=TRUE,nf=4),cex=rep(0.7,2)) Error in rep(p * X.svd$d[sec], c(n, n)) : invalid number of copies in "rep" A bit of exploration in the

I there was a discussion on the vorbis list about Real Audio SureStream (tm) format. The basic idea was that they put multiple RA files with different compression levels. So when they have to switch the bit rate due to bandwidth changes, they choose from the streams they have. Since peeling is a long time away, it could be implemented with ogg vorbis multiplexing several times the same

Hello, I am new to the RODBC package, but I have looked over the PDF as well as a few websites that go over the SQL language. I can connect to my database fine using >channel<-odbcConnect("Oracle ODBC") # then am prompted to enter my user id and password After that I'd like to use the odbcQuery function and the SQL statement: SELECT * FROM table_name WHERE SAMPLE_YEA LIKE

Hi, Does anyone know how to pass dynamic sql statement to RODBC function "odbcQuery()" or "sqlQuery()"? eg.: under R session, I did: >library(RODBC) >channel<-odbcConnect(...) >data1<-2.5 >data2<-5.0 I want to construct the INSERT sql statement using variables "data1" and "data2" and pass this statement to odbcQuery() . Can I do this?

1. Can I avoid having RODBC use so much memory (35 times the data size or more) making a data.frame & then .rda file via. sqlQuery/save? 2. If not, is there some more appropriate way from w/in R to pull large data sets (2-5GB) into .rda files from sql? [R] reducing RODBC odbcQuery memory use? From: WILLIE, JILL <JILWIL_at_SAFECO.com> Date: Thu 25 Jan 2007 - 22:27:02 GMT

New to R, sorry if one or either of these is an inappropriate list for a question like this below; please let me know if this is a general help question. Jill Willie Open Seas Safeco Insurance jilwil at safeco.com -----Original Message----- From: WILLIE, JILL Sent: Thursday, January 25, 2007 2:27 PM To: r-help at stat.math.ethz.ch Subject: reducing RODBC odbcQuery memory use? Basic

I'm trying to load Affy Annotation data from an Access database into R using RODBC. This has worked fine for quite some time. The bug seems to be correlated to RODBC versions 1.1-7 and later. Works fine: R 2.2.0 with RODBC 1.1-4; R 2.3.0 or R 2.4.1 with RODBC 1.1-6 Fails: R 2.3.1 with RDOBC 1.1-7; R 2.4.1 with RODC 1.1-7 or 1.1-8 Details ===== This works fine: Version 2.2.0

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

You could construct your SQL statement as a character string using paste() and pass this as an argument to sqlQuery. Maybe something like this will work for you: >data1<-2.5 >sql.statement <- paste("SELECT * FROM somewhere WHERE something=", data1, ";", sep="") >library(RODBC) >channel <- odbcConnect(...) >sqlQuery(channel, query =

R-help users, Thanks in advance for any assistance ... I truly appreciate your expertise. I searched help and could not figure this out, and think you can probably offer some helpful tips. I apologize if I missed something, which I'm sure I probably did. I have data for many "samples". (e.g. 1950, 1951, 1952, etc.) For each "sample", I have many data-frames.

Dear list, RODBC is mostly working very well on Windows XP talking to MS SQL Server. 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()

Hi WizaRds, I'm experiencing a problem connecting to an Oracle 10g database via RODBC (I'm getting this on Microsoft XP). The same SQL queries via PL/SQL Developer work just fine, but when I pump the query through sqlQuery in RODBC then I get a data frame back with 0 rows. I cut the query down alternating between PL/SQL and RODBC until I figured that it's some kind of row limit or

Howdy, I'm trying to use R to access Oracle 8i using the RODBC package On Linux Red Hat 7.3. Specs R version 1.51 Driver: Easysoft ODBC - Oracle driver Driver Manager: unixODBC I get the following error when trying to executing RODBC commands. Can anybody give me pointers as to what I'm missing or doing wrong > library(RODBC) > channel <- ("DSNName") >

I am trying to connect to an internal database and use the sqlQuery command to reduce and retrieve data using the following code: channel <-odbcConnect("some_dsn", uid="", pwd="") txt<-'SELECT Date, Region, Price FROM TableXYZ WHERE Type="Domestic"' sqlQuery(channel, cat(txt,"\n"),errors=TRUE,) close(channel) However, I get the

Dear R-SIG-Debian, while trying to query data from an SQLite database through RODBC on Debian testing, R crashes with the following message: library(RODBC) con3 <- odbcConnect("test3") # 'test3' being an ODBC datasource configured with SQLite3 driver, # but the same happens with SQLite driver sqlQuery(con3, "select * from test") # 'test' being any table