similar to: Querying sqlite through RODBC causes R to crash

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

Dear r helpers I run the following code for nested logit and got a message that Error in optim(c(0, 0, 0, 0, 0.1, -2, -0.2), fr, hessian = TRUE, method = "BFGS") : initial value in 'vmmin' is not finite What does this mean? and how can I correct it? Thank you June > yogurt = read.table("yogurtnp.csv", header=F,sep=",")> attach(yogurt)>

Dear Rhelpers I have the problem with initial values, could you please tell me how to solve it? Thank you June > p = summary(maxLik(fr,start=c(0,0,0,1,0,-25,-0.2))) Error in maxRoutine(fn = logLik, grad = grad, hess = hess, start = start, : NA in the initial gradient > p = summary(maxLik(fr,start=c(0,0,0,1,0,-25,-0.2),method="BFGS")) Error in optim(start, func, gr =

Full_Name: George Russell Version: 2.10.0 OS: Windows XP Professional Version 2002 Service Pack 2 Submission from: (NULL) (217.111.3.131) Typing the following command into R --vanilla causes R to crash: k <- intToUtf8(rep(1e3,1e7)) This is the output of sessionInfo(): R version 2.10.0 (2009-10-26) i386-pc-mingw32 locale: [1] LC_COLLATE=German_Germany.1252 LC_CTYPE=German_Germany.1252

Hi all, I am encountering an RODBC problem in R 2.15.1 in windows 64 bit which I do not encountered in the same set up in windows 32 bit (the latest binary version of RODBC in both cases from the same depository gotten by install.packages(‘RODBC’), Oracle ODBC client software installed in 64 and 32 bit respectively) 1. The code looks like library(RODBC) credentials <-

Dear list, I have a balance connected to the serial port of a windows machine ("COM1") and I read the text output of the balance with scan("COM1", what="character", sep="\n", n=1) after calling the previous line I press the print key on the balance which triggers sending one line of text to the serial connection and with R 2.9.2 I get something like Read

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,

Dear list, I'm tackling an empiric research problem that requires me to address a whole bunch of conceptual and/or technical details at the same time which cuts time short for all the nitty-gritty details of the "components" involved. Having said this, I'm lacking the time at the moment to deeply dive into parallel computing and HTTP requests via RCurl and I hope you can help me

My decision tree grows only with one split and based on what I see in E-Miner it should split on more variables. How can I adjust splitting criteria in R? Also is there way to indicate that some variables are binary, like variable Info_G is binary so in the results would be nice to see "2) Info_G=0" instead of "2) Info_G<0.5". Thank you in advance! And thanks for Eric who

Greetings, I have a nagging problem with contrasts and I can't seem to resolve it. A factor exists with four levels (lib1, lib2, con1, con2) and when I check the contrasts or set the contrasts to any of the prespecified ones, I do not get the exact contrasts necessary to test the theoretically relevant ones. I need orthogonal contrasts that look just like this matrix: con1 con2

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

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

Hello, We are having some strange issues with RODBC related to integer columns. Whenever we do a sql query the data in a integer column is 150 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

I have been using RODBC to 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

Hi, I'm using R-2.8.1 for windows. I wrote a script calls the RODBC package to run sql queries against an oracle database. It runs fine when run from the rconsole and returns a data.frame with a summary for a set of experiments. I want to run this script using the rinterface.RunRFile command in an excel plugin, using the rexcel package. When I run the code from my excel plugin I

R 2.8.1 Ubuntu 64amd RODBC 1.2-5 --------------------------------- 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,

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

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)

Dear developers, I have come across a (somewhat strange) change in the encoding of Sweave output from R-2.9.2pat to R-2.10.0beta (apparently specific to Rgui) on Windows installations. Of course, the NEWS file contains quite a few changes concerning encoding, but I was not able to locate an entry which explains the observed behaviour. I am not very familiar with encodings/locales/codepages,