similar to: reducing RODBC odbcQuery memory use?

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 have been searching all day & most of last night, but can't find any benchmarking or recommendations regarding R system requirements for very large (2-5GB) data sets to help guide our hardware configuration. If anybody has experience with this they're willing to share or could anybody point me in a direction that might be productive to research, it would be much appreciated.

I would like the option to specify alternative scale parameters when using the gamma family, log link glm. In particular I would like the option to specify any of the following: 1. maximum likelihood estimate 2. moment estimator/Pearson's 3. total deviance estimator Is this easy? Possible? In addition, I would like to know what estimation process (maximum likelihood?) R is using to

We are wanting to use R instead of/in addition to our existing stats package because of it's huge assortment of stat functions. But, we routinely need to fit GLM models to files that are approximately 2-4GB (as SQL tables, un-indexed, w/tinyint-sized fields except for the response & weight variables). Is this feasible, does anybody know, given sufficient hardware, using R? It appears to

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

I have compiled and linked a 64 bit version 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,

I have compiled and linked a 64 bit version 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,

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 =

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?

Dear R cracks I am trying to fetch 38 Tables from 38 ESRI Geodatabases through an ODBC connection. I stored the 38 channels in a list and the 38 tablenames in an other list. With a for(i in 1:38) .... sqlFetch(....) I try to read the tables into a third list. But always after a certain amount of rounds (mostly 16) i get Fehler in odbcQuery(channel, query, rows_at_time) : Calloc konnte

Dear R users, I am trying to connect R to data that is in a Access Database but I have problem with the construction of queries using special characters. I am using RODBC package. The following is working : > MyQuery<-paste("SELECT first( (DateHeure) ) , avg(NNO3_AT322_OUT_moy) AS Cond FROM Colonne_3 ") > Col3<-sqlQuery(con, query=MyQuery) > Col3

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

I have an MS Access database with one table and one column holding rep(1:10) I use: library(RODBC) channel <- odbcConnect("test") sqlQuery(channel, paste("SELECT col FROM tblTest"), believeNRows=FALSE) and get: 49 50 51 52 53 54 55 56 57 12337 What? The above should, of course, read: 1 2 3 4 5 6 7 8 9 10 I tried the 'odbcQuery' /

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

Dear all, I have some problems with importing data from an Access data base via RODBC to R. The data base contains several tables, which all are imported consecutively. One table has a column with column name "NO". If I run the code attached on the bottom of the mail I get no complain, but the column name (name of the respective vector of the data.frame) is "Expr1014" instead

Recently after upgrading to 1.2 Beta3 from 1.1.13, I started to defer mail. After looking into it deeper, it looks like Dovecot/sieve now asks for a tmp folder in the imap (maildir) folder. Once I added the tmp folder as the logs indicants, the mail was processed normally. I have split my Inbox and imap store to different folder. Looking at what it's trying to do, it looks to me that

Dear all, I've encountered a curious problem. I am trying to run an SQL query using sqlQuery() function in RODBC. The query works fine when run in a stand-alone SQL browser (Microsoft Query Analyzer, in particular). However, when I use the exact same thing from sqlQuery() function, I get the following error: Error in "[.data.frame"(data, , ) : not all specified columns exist

R Version : 2.14.1 x64 Running on Windows 7 Connecting to a database on a remote Microsoft SQL Server 2012 The short form of my problem is the following. I have an unordered vectors of names, say: names<-c("A", "B", "A", "C","C") each of which have an id in a table in my db. I need to convert the names to their corresponding ids. I

I have searched the archives for using insert into to update spreadsheets using RODBC and have come up short. So, first off, is it possible? I have put together a dummy xls table (c:\foo.xls)for exploring possibilities of RODBC. Ultimately, I am interested in replacing much of our previous use of vba macros with R ( I'd prefer elimination, but will take what I can get ). In order to