similar to: R connectivity with Oracle DB

Hi Friends, I am trying to import a table from SQL server to R(2.9.0), however i am getting errors while running the below codes. Can anyone identify and let me know where did i go wrong??? Thanks in anticipation :) library(RODBC) myconn <- odbcConnect("RDATABASE") myconn RODB Connection 6 Details: case=nochange DSN=RDATABASE Description=Database for R UID=Madana_Babu

Hi R-friends, Attached is the SAS XPORT file that I have imported into R using following code library(foreign) mydata<-read.xport("C:\\ctf.xpt") print(mydata) I am trying to maximize logL in order to find Maximum Likelihood Estimate (MLE) of 5 parameters (alpha1, beta1, alpha2, beta2, p) using NLM function in R as follows. # Defining Log likelihood - In the function it is noted as

HI R users, I would appreciate information/examples/suggestions on building GUIs for R applications. I am currently working on a project that would require the following functionalities : 1) Display a window to the user. Provide a function to scan local drive and choose dataset file. 2) Display the column names for the user to choose the dependent variable and the independent variables. 3) Fit

Hello, I am running Linux, I have downloaded instantclient-basiclite-linux32-11.2.0.2.0.zip instantclient-sqlplus-linux32-11.2.0.2.0.zip instantclient-sdk-linux32-11.2.0.2.0.zip instantclient-precomp-linux32-11.2.0.2.0.zip All these tarballs are unzipped in /usr/local/lib/instantclient, I have added this path in the library path of the host. I can run sqlplus and proc, they do not complain

Hi R users and Dr. Uwe Ligges: I read on the ROracle pre-compiled binary README file that: "Although the package ROracle passes make check, it seems to be dangerous to distribute it: I do not have the software available this package depends on." Why it is dangerous to use ROracle for windows? What software does ROracle depends on in windows platform? Is there a GNU solution for an

Hi, I need to use ROracle to communicate with Oracle from R program in windows environment. I am using Oracle 10g, R 2.6.2. I found a pre-compiled binary for ROracle for Oracle version 9.2. When I am trying to use it with Oracle 10g I get the following error: con <- dbConnect(drv, "user/passwd at dbname"); Error in function (classes, fdef, mtable) : unable to find an inherited

Hi, I am new to R. I need to communicate with Oracle from R program in windows xp. So I am planning to use ROracle. I downloaded the ROracle src from the site below: http://cran.r-project.org/web/packages/ROracle/index.html I am using R version 2.6.2 and Oracle 10g. I followed the instructions to build ROracle. When I try to compile the source src/Makefile.win I get the following error:

Hello, I'm trying to find if the access within a loop body is using the loop induction variable, and to get the start and end indices of the loop. for(int i = start; i < end; i++) { A[i] = 0; } Let's say, I want to replace this with a function call 'zero(A,start, end)' How can I get the Value for start and end, and see if the index is same as loop induction variable?

I have been looking for a statistical package that I can implement in our application and I came across R. We run an n-Tier environment with an Oracle 10g backend. Our design is to keep all business logic in the backend. What I would like to do is call R from pl/sql. I noticed that ROracle is designed to connect with and process from a client perspective. I actually would be running in the

Hello, Attached is a mail regarding question how to insert Date field using ROracle package. I am stuck with this problem and appreciate receiving help from gurus on this list. Code used mainly is: library(ROracle) ### --- Version 0.53 drv <- dbDriver("Oracle") con <- dbConnect( drv, "user/passwd") d <- data.frame(CDATE = "2004-03-10 10:12:00") ps

Dear all i got a problem in monthly mean temperature. here i am attaching the data set as well as the plot i got with the following command plot(month,type='n') plot(month,X1999) this command gave the plot where the month names are in alphabetic order, i want the plot in monthly sequence could you please suggest me how can i solve my problem? thanking you regard madan

Con oracle puedes usar, si tu máquina es de 64bits la librería Roracle que va muy bien y no es muy complicada de instalar. Hay que distinguir 2 cosas, cuando accedes a la base de datos y allí haces la consulta, eso da igual si lo haces con RODBC o Roracle y cuando cargas los datos en tu data.frame, en esta operación, ya no está usando el gestor de base de datos sino tu propio R. La velocidad y

Hi all. (I am sending this querry here because it is somehow relating to rsync. If i am wrong please pardon me.) I am doing following on these windowsXP and Vista. I am trying to get only incremental backup using "rdiff-backup" (that also uses rsync). I have installed gcc compiler and by following the steps given in http://katastrophos.net/andre/blog/2005/11/02/rdiff-backup-on-windows/

dear all contributors i am new R user i want to upgrade my R version from 2.7.1 to 2.8.1 i tried myself, but i could not do it as R is different from other software could anyone guide me please warm regard madan student University of Bergen Windows Live™: Keep your life in sync. Check it out. Windows Live™ Hotmail®: Chat. Store. Share. Do more with mail. See how it works.

Dear all i could not estimate the optima value or range value in unimodal plot in glm please help me out thanking you regard madan _________________________________________________________________ Hotmail® has a new way to see what's up with your friends. orial_WhatsNew1_052009 [[alternative HTML version deleted]]

Estimados usuarios de R Buenos días a todos los usuarios. Estamos intentando abrir una base de datos de ORACLE en R. Es una base de datos muy grande con datos inviduales sobre empleo de los individuos y sus caracteristicas. He echado un vistazo a https://www.r-bloggers.com/connecting-r-to-an-oracle-database/,y aparecen algunas instrucciones y el paquete RODBC. Alguien tiene experiencia con estas

Dear R users, I'm working on implementation of hydrometeorological DB in Oracle9i and would like to use R, as a plotting engine for graphs and maps and also to perform some non trivial statistics on DB data using R. Thus any links with examples or efforts on: - general DB and R cooperation - Oracle91 and R cooperation - Oracle PL/SQL and R are welcomed. Thanks in advance, Rado --

Dear all, I tried the following in R: >library(ROracle) >ora <- dbDriver("Oracle") >channel <- dbConnect(ora, user = "scott", password="tiger",dbname="abcdef") >rs <- dbSendQuery(channel, "select * from USArrests") >while(!dbHasCompleted(rs)) { xxx <- fetch(rs, n = 5000) } + + + > xxx Error: Object

Hi there, I am trying to install ROracle but I get this error. I have an error in reconcilePropertiesAndPrototype. (My LD_LIBRARY_PATH is set with the oracle lib) Thanks, Mathieu # R CMD INSTALL --configure-args='--enable-extralibs' ../ROracle_0.5-5.tar.gz * Installing *source* package 'ROracle' ... creating cache ./config.cache checking how to run the C preprocessor... cc -E

Dear R-users, In order to use ROracle (v. 0.5-5) package I compiled R-1.9.1 on Linux (2.4.20-28.9smp) and installed it. I need to use Oracle9i on Solaris. When executing "library(ROracle)" I got the following error message: > library(ROracle) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library