search for: rows_at_time

...------------------------------- This was a hard-to-track bug for me, because sqlQuery() did not fail - instead, it looked like it returned some good data and some NA where there should have been numbers and 0 where there should have been NAs. I did: (a) sqlQuery( o, qry, as.is=TRUE, errors=TRUE, rows_at_time=1024 ); (b) sqlQuery( o, qry, as.is=TRUE, errors=TRUE ); My qry was a bit complex, with an outer join, so the first thing I did was check from a win32 bit machine and check on 64amd with the mysql client command-line. Both worked fine. Both (a) and (b) work fine from a XP Pro 32-bit R 2.8.1 inst...

...o the RODBC PDF, the odbcQuery command should accept any valid SQL statement. Is there something wrong with my syntax? I have tried a few things, like attaching the tables to the data frame but with no luck. According to the PDF, I should be able to use this argument: >odbcQuery(channel, query, rows_at_time,=attr(channel, "rows_at_time")) I have also tried to use arguments like: >sqlColumns(channel, "SAMPLE_YEA") but with no luck. Any help with this would be much appreciated! Thanks in advance, Megan

...ame happens with SQLite driver sqlQuery(con3, "select * from test") # 'test' being any table *** caught segfault *** address 0x438, cause 'memory not mapped' Traceback: 1: .Call(C_RODBCQuery, attr(channel, "handle_ptr"), as.character(query), as.integer(rows_at_time)) 2: odbcQuery(channel, query, rows_at_time) 3: sqlQuery(con3, "select * from test") Possible actions: 1: abort (with core dump, if enabled) 2: normal R exit 3: exit R without saving workspace 4: exit R saving workspace Selection: 1 aborting ... Segmentation fault This is what ses...

...bit respectively) 1. The code looks like library(RODBC) credentials <- read.csv("~/credentials.csv", head=T, row.names=1) db <- odbcConnect(dsn="DSN", uid=credentials["DSN", "username"], pwd=credentials["DSN", "password"], rows_at_time=1024) on which the odbcConnect call fails with the following error code Error in nchar(uid) : 'nchar()' requires a character vector ( credentials are processed correctly and credentials["DSN", "username"] correctly returns – by the way a factor – [1] _username_ Le...

Hi, I am trying to query a Sybase database on my new windows 7 machine. I am using native sybase driver "Adaptive server Enterprise" following is example code conn <- sprintf("driver=Adaptive server Enterprise;server=PHKSESMD01;database=smd_live;uid=temp_user;password=temp_pass;port=2301") chan <- odbcDriverConnect(conn) x <- sqlQuery(chan,sql,as.is=as.is)

...n "rm(list = ls(all = T)); gc()" and the import several times I get the following error: Error in odbcTables(channel) : Calloc could not allocate (263168 of 1) memory In addition: Warning messages: 1: Reached total allocation of 447Mb: see help(memory.size) in: odbcQuery(channel, query, rows_at_time) 2: Reached total allocation of 447Mb: see help(memory.size) in: odbcQuery(channel, query, rows_at_time) 3: Reached total allocation of 447Mb: see help(memory.size) in: odbcTables(channel) 4: Reached total allocation of 447Mb: see help(memory.size) in: odbcTables(channel) which is surprising t...

...databases 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 nicht (67108864 von 1) Speicher zuteilen Zusätzlich: Warning message: Reached total allocation of 1021Mb: see help(memory.size) When I keep on trying the rounds will stop at 1. Any sugestions? Sincerely Lukas -- -- Arbeit: Tel: +41 44 632 55 98 ETH Zürich Institut fü...

...t RODBC seems to be an order of magnitude slower in retrieving rows from a table than ODBC (or JDBC) access in other tools. I'm wondering why that is, and whether there are things I can do to improve performance beyond what I've tried. I've checked the documentation, and have tried the rows_at_time= and buffsize= options, which helped a little, but it is still running much, much slower than what I'm seeing from other querying tools. I'm running R version 2.7.1 on Windows XP 32-bit, RODBC version 1.2-3, and connecting to SQL Server 2005 running on a separate server via an ODBC DSN...

...actual data points then 150 0's then 150 actual data points then 150 0's. However, our database actually has numbers where the 0's are filled in. Furthermore, other datatypes do not have this problem: double and varchar are correct and do not alternate to null. Also, if we increase the rows_at_time to 1024 there are larger gaps between the 0's and actual data. The server is a sybase IQ database. We have tested it on a different database sybase ASE and we still get this issue. For example : We have the following query sqlString = "Select ActionID, Velocity from ActionDataTable&quot...

...uot;", pwd="") txt<-'SELECT Date, Region, Price FROM TableXYZ WHERE Type="Domestic"' sqlQuery(channel, cat(txt,"\n"),errors=TRUE,) close(channel) However, I get the following error immediately after sqlQuery command: Error in odbcQuery(channel, query, rows_at_time) : 'getCharCE' must be called on a CHARSXP I believe my connection is good because I used the following commands to successfully view the columns: sqlColumns(channel, TableXYZ) There doesn't seem to be much info on "getCharCE" and/or "CHARSXP. Any guidance the group...

...1.1-7 Date: 2006-05-24 > library("RODBC") > channel <- > odbcConnectAccess("S:/Bioinformatics/Software/Affy/Data/MOE430A/MOE430A.mdb") > moe430a <- sqlFetch(channel,"Annotation", as.is=TRUE) Error in odbcQuery(channel, query, rows_at_time) : Calloc could not allocate (67108864 of 1) memory In addition: Warning message: Reached total allocation of 1024Mb: see help(memory.size) R version 2.4.1 (2006-12-18) Package: RODBC Version: 1.1-8 Date: 2007-01-02 > library(&quo...

...connect to an Access database to capture data to create plots. Recently I found incomplete charts. Upon investigation I discovered that the data retrieved stopped at 3276 rows (records) out of a table with over 5600 records. I've tried changing "max","buffsize", and "rows_at_time" but it still returns only 3276 rows. Is this a limitation in R or Access? Is there an easy work around? Thanks for any helpful suggestions. -- View this message in context: http://www.nabble.com/RODBC-Access-limit--tp18253443p18253443.html Sent from the R help mailing list archiv...

...me(Hello="Hello") But will give me the error when Script.R is something like: inSet <- "TEST0000853" library("RODBC") query <- function(qu){ con <- odbcConnect ("Development ",uid="username",pwd="password",believeNRows=FALSE,rows_at_time=50) sqlQuery(con,qu) } qu <- paste("m.parentid as SET from setmap m where m.childid in (select t.experiment from experimentsets t where t.setname='",inSET,"')",sep="") ExperimentSet <- as.character(query(qu)[,1]) The error only occurs when I call...

I have compiled and linked a 64 bit version of R (R 2.9.2) and the corresponding 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,

...( format(DateHeure, \"00\")) ) , avg(NNO3_AT322_OUT_moy) AS Cond FROM Colonne_3 ") > Col3<-sqlQuery(con, query=cat(MyQuery)) SELECT first( format(DateHeure, "00")) ) , avg(NNO3_AT322_OUT_moy) AS Cond FROM Colonne_3 Erreur dans odbcQuery(channel, query, rows_at_time) : 'getEncChar' doit ?tre appel? sur un CHARSXP Do you have any idea on how to proceed? With Best regards Pascal Boisson ___________________________________________________________________________________ Protegeons ensemble l'environnement : avez-vous besoin d'imprimer ce co...

...respuesta, algo gen?rico como puede ser: cn <- odbcDriverConnect(connection="Driver={SQL Server Native Client 11.0};server=localhost;database=AdventureWorksDW2012;trusted_connection=yes;") dataFetchEUR <- sqlFetch(cn, 'vResellerSalesAmountEUR', colnames=FALSE, rows_at_time=1000) Reemplace lo menos posible, si falla posiblemente hay un mensaje de error con alguna pista. Javier Rub?n Marcuzzi El 2 de marzo de 2018, 11:19, Jes?s Para Fern?ndez <j.para.fernandez en hotmail.com<mailto:j.para.fernandez en hotmail.com>> escribi?: Perdon, corrijo, es justo e...

Perdon, corrijo, es justo eso... En cuanto hay uan cadena de tipo varchar falla. Es por temas de codificaciones en el driver. ?Como cambio la codificacion? Un saludo Jesus ________________________________ De: David Luna <ofc587a87 en gmail.com> Enviado: viernes, 2 de marzo de 2018 15:02 Para: Jes?s Para Fern?ndez Cc: r-help-es en r-project.org Asunto: Re: [R-es] Problemas de conexion con

...all to setSqlTypeInfo(). ********* ********* `RODM_open_dbms_connection` <- function( # # Open an ODBC connection to the Oracle Database # dsn, uid = "", pwd = "") { library(RODBC) channel <- odbcConnect(dsn = dsn, uid = uid, pwd = pwd, case = "toupper", rows_at_time=1) driver <- odbcGetInfo(channel)[[1]] setSqlTypeInfo(driver, list(double="double precision", integer="integer", character="varchar(255)", logical="varchar(255)")) ********* ********* I am confused why would there be locked binding here. Sorry , if I...

Hello all, I have a strange / interesting problem that might be 'R' settings themselves, or it might be something with the OS. I am using the RODBC library. I have a script that goes out and, before making a query for a big data set, will first query for the column names of the data set. The column names could sometimes be quite long (e.g., "Time Background Estimation