similar to: Oracle database connction from R in Linux

Hi I'm presently trying to connect to Oracle through RODBC / UnixODBC on linux (Red Hat 5). I've successfully connected through the easysoft drivers but the trial license has run out and I'm trying to connect via the default Oracle 11G driver. However I'm getting the following error > library(RODBC) > setwd (paste("/home/oracle/scripts/R")) > channel

Has anyone tried to connect parallely to an analog PBX system? __________________________________ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com

Thanks. It works! Besides disabling selinux, we updated to 1.2.5-1 today, since it plays nicer to oracle RAC (installed on the same 2 node cluster) by way of rebooting instead of panicing the kernel when one of the private nics is disconnetcted. While I'm on that topic, do you know it there is any possibility of telling the ocfs2 daemon which node is the preferred one to kill in a

Hola a todos, Tengo un problema con RStudio y la conexión a una base de datos. Desde la terminal no tengo problemas para ejecutar, por ejemplo: library(RODBC) channel <- odbcConnect("MiBaseDatos", uid = "MiUsuario", pwd = "MiContrasena") datos <- sqlQuery(channel,"SELECT TO_CHAR(S.B_STOD_DATO,'YYYY') \ , M.STODNR \ ... ... ...") pero desde

Carlos, al parecer tengo instalado el paquete RODBC en : /home/luisr/R/i686-pc-linux-gnu-library/3.0/RODBC/ no hay nada en (carpeta vacia): /usr/local/lib/R/site-library/ en el directorio: /usr/local/lib/R/site-library hay paquetes que vienen con R pero RODBC no saludos, Luis -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- Luis Ridao Cruz Faroe Marine Research Institute Nóatún 1,

Hi all - I am trying to install ROracle for linux machines ... I have read the INSTALL documentation and followed the directions for setting the paths as follows: export PATH=/app/oracle/product/10.2.0/db_1/bin:$PATH [manthony@diamondback ~]$ export LD_LIBRARY_PATH=/usr/lib:/usr/lib64:/lib:/app/oracle/product/10.1.0/db_1

Dear R-users I'm running a maximum likelihood procedure using the spg package. I'd like to save some output produced in each iteration to a file, but if I put the capture.output() within the function I get the following message; Error in spg(par = startval, fn = loglik, gr = NULL, method = 3, lower = lo, : Failure in initial function evaluation!Error in -fn(par, ...) : invalid argument

No, no estoy usando Rstudio Server El 1 de abril de 2014, 9:07, Carlos J. Gil Bellosta <cgb@datanalytics.com>escribió: > Una pregunta... no estarás utilizando RStudio server, ¿verdad? > > En tal caso, lo que tienes que hacer es configurar > /etc/rstudio/rstudio.conf tal como indica en > > http://www.rstudio.com/ide/docs/server/configuration > > En particular,

Hola, ¿qué tal? ¿Puedes comparar la salida del comando Sys.getenv("LD_LIBRARY_PATH") en una sesión en la que funciona RODBC y otra en la que obtienes el error anterior? Un saludo, Carlos J. Gil Bellosta http://www.datanalytics.com P.D.: A propósito, también he estado tratando de utilizar RODBC en Linux y me he acabado rindiendo. Sobre todo porque RJDBC funciona bastante bien.

R-sig-Debian help, I have installed an ODBC Driver for Linux. I want to connect to our database through R via: >library(RODBC) >con <- odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") Warning message: In odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") : ODBC connection failed I don't really know whether this

Hi, I purchased a G.729 1 channel codec license from digium. And installed as per the documentation. Then configured the sip.conf to use the new codec. For that, I am added the following entries in sip.conf (via web interface, as i am using asterisknow 1.5) disallow=all allow=g729 allow=ulaw allow=alaw allow=gsm After that, when try to call through the PSTN line I can hear the voice of

Hi all!! I would like to know if anyone has experienced this behaviour with ROracle package. I'm attaching information to reproduce the issue. Bug maybe? Thank you very much for your attention. Ramon. ################################################################## ################################################################## oraExecStatement BUG : RS-DBI driver: (ORA-02005:

Pues ahí lo tienes. De alguna manera R (a través de RStudio) no está incorporando el directorio /u01/app/luisr/product/11.1.0/client_1/lib donde se ve que tienes las librerías de ODBC al "LD path". Échale un vistazo a https://support.rstudio.com/hc/communities/public/questions/200641818-How-to-configure-libPaths-?locale=en-us Aparentemente RStudio tiene su propio sistema para

Hi all CentOS users, I have writing shell script for check oracle processes in real time and alert with e-mail. I read script like below NUMBEROFPRO=/oracle/10.2.0/db_1/bin/sqlplus / as sysdba <<EOF1 |grep processes|awk '{print $2}' SELECT resource_name,current_utilization,limit_value FROM V\$RESOURCE_LIMIT WHERE RESOURCE_NAME IN ('processes','sessions'); quit EOF1

I?ve an issue related to Oracle 10g RAC. I?ve 2 node cluster each being Dell 2850 Server with RHEL 4.0 I?ve EMC CX300 SAN storage with following partitions /orasoft 10 Gb OCFS2 File system /oracrs 2 Gb OCFS2 File system /orabackup 100 Gb OCFS2 File system The datafiles are on ASM which is not directly visible in OS.

Dear R-users, I'm running an MLE procedure where some ODEs are solved for each iteration in the maximization process. I use mle2 for the Maximum likelihood and deSolve for the ODEs. The problem is that somewhere along the way the ODE solver crashes and I get the following error message: DLSODA- Warning..Internal T (=R1) and H (=R2) are such that in the machine, T + H = T on the next

> bundle exec rails s => Booting WEBrick => Rails 3.1.5 application starting in development on http://0.0.0.0:3000 => Call with -d to detach => Ctrl-C to shutdown server Warning: NLS_LANG is not set. fallback to US-ASCII. [2012-12-19 12:17:10] INFO WEBrick 1.3.1 [2012-12-19 12:17:10] INFO ruby 1.9.3 (2012-10-12) [x86_64-linux] [2012-12-19 12:17:10] INFO WEBrick::HTTPServer#start:

Hi there, I'm trying to solve 2 nonlinear equations in 2 unknowns using the BB package. The first part of my program solves 3 ODEs using the deSolve package. This part works. The output is used as parameter values in the functions I need to solve. The second part is to solve 2 equations in 2 unknowns. This does not work. I get the error message "unexpected end of input". So what

Hi all, Just noted this behavior in the past couple of days, where if R is started in a shell script such as: gnome-terminal [-e][-x] R or in ESS (version 5.2.12 with Emacs or XEmacs), the LD_LIBRARY_PATH environment variable is not properly appended to, resulting in the loss of the pre-start value. This is using R Version 2.2.1 Patched (2006-02-28 r37448) on FC4. I noted this when

Hi, I am using asterisknow 1.5.0 and Wildcard TDM410P card. Everything is working fine except the caller ID of incoming call from PSTN line. The phone display is showing "Unknown" when there is an incoming call. I think the same problem listed here: https://issues.asterisk.org/view.php?id=6683 There is one patch on this link but i don't know how to apply patch on asterisknow.