similar to: R started in terminal shell script or ESS steps on LD_LIBRARY_PATH?

Here is the thing. All workstations in the network have the /etc/profile modified and set up to call a profile script in the network that sets up variables that we need here. Here $LD_LIBRARY_PATH and other variables get set, fixed, or modified to support our development process. The weird thing is that while in a TTY the $LD_LIBRARY_PATH is fine and retains its value. But if I log in to the gui

I'm trying to pull data from multiple MS SQL Sever databse in R. I can access the databases one at a time, but the tables are to large to pull the entire tables then join then in R. So I need to do a SQL join that will join the tables from the each of the databases. How do I combine the connection so that I can implement it in my sql query below. I'm currently getting the following error:

I just joined and though I did quickly read the posting guide it is quite possible not going to be a perfect posting. For one I tried to figure out how to reply to an existing message on the topic. I gave up but figured I keep at least the same subject. In a gist I get an empty data frame after issuing the following select query from R 2.9.1 to Oracle 10.2.0.1 64bit via RODBC 1.3 and Oracle 11g

I haven't been able to find any help on this and am really struggling. I've been using RODBC 1.1-3 and R(D)COM v1.35 for a little over a year successfully with my Access Database, and now im switching to Oracle 9i. I use R 2.0.1 on a Windows XP platform, 1GB ram, 2GHz Intel Processor) When I connect through the Rgui R console, the connection is successful (but through VB the attempt

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,

Hello, I'm trying to get the LD_LIBRARY_PATH set from .bash_profile (Centos 5.3 fully updated). This is a part of my .bash_profile: export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/szyman/omnet/omnetpp-2.3p1/lib export R_HISTSIZE=2000000000 Everything works fine under standard ssh login, but under NX client the LD_LIBRARY_PATH variable is missing (the R_HISTSIZE is exported properly). Any

This change allows the run scripts of virt-v2v and libguestfs to be chained. --- run.in | 16 +++++++++++++--- 1 files changed, 13 insertions(+), 3 deletions(-) diff --git a/run.in b/run.in index 9388398..7cef715 100755 --- a/run.in +++ b/run.in @@ -37,9 +37,19 @@ b=@abs_builddir@ export TMPDIR="$b" # Set local environment relative to this script. -export

Using R-2.8.0 and R-2.8.1, I get behaviour like this: R version 2.8.0 (2008-10-20) Copyright (C) 2008 The R Foundation for Statistical Computing ISBN 3-900051-07-0 [....] > Sys.getenv("LD_LIBRARY_PATH") LD_LIBRARY_PATH

hi, i am using the RODBC package to read .xls files. now after i installed the package and loaded the library and tried to read a file this is the error i got. >channel<-odbcConnect("D:/rstuff/1.xls") Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: ODBC connection failed

Hello, I'm using R 2.2.0 on a Mac and attempting to use the RODBC package to connect to a PostgreSQL server on the local network. I can't tell whether my problem is in R, or in ODBC setup. I got drivers from OpenLink, created a dsn and tested it using the iODBC application. then I load the RODBC package, use this code and get the following error. I tried with both the

I am trying to connect sybase sql databast from R using RODBC pkg and getting the following error ( i chnaged names to my*** but when I actually execute it, I put down names explicitly not calling some character strings) > channel = odbcConnect(dsn='mydsn',uid='myid',pwd='mypasswd') Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [iODBC][Driver

Well, I've found that the line in INSTALL that gives the problem is gzip -dc "${1}" | (cd "${tmpdir}" && tar -xf -) ("tar: /usr/local/lib/libpthread.so.0: version `GLIBC_2.2' not found (required by /lib/librt.so.1)") If I run that command from the shell, i.e., gzip -dc KernSmooth_2.22-7.tar.gz | (cd /tmp/R.INSTALL.2186 && tar -xf -) it runs

Overwriting LD_LIBRARY_PATH broke some tests when running with fakeroot. --- align/Makefile.am | 2 +- cat/Makefile.am | 2 +- clone/Makefile.am | 2 +- df/Makefile.am | 2 +- edit/Makefile.am | 2 +- fish/Makefile.am | 2 +- haskell/Makefile.am | 2 +- ocaml/Makefile.am |

Hi. Consider the following situation: Solaris 8, /usr/local has gcc 2.95, my home has gcc 3.4.3, my gcc is first on PATH, LD_LIBRARY_PATH is unset (everything is perfect since I always use -R). In fact, programs compiled with my gcc do not work if LD_LIBRARY_PATH is set to something which has /usr/local/lib before home/lib, because it overrides stored path (-R) and I got libgcc_s.so.1

Hi. Consider the following situation: Solaris 8, /usr/local has gcc 2.95, my home has gcc 3.4.3, my gcc is first on PATH, LD_LIBRARY_PATH is unset (everything is perfect since I always use -R). In fact, programs compiled with my gcc do not work if LD_LIBRARY_PATH is set to something which has /usr/local/lib before home/lib, because it overrides stored path (-R) and I got libgcc_s.so.1

Dear R-help, I am trying to use a package (not from CRAN) which includes two shared library (.so) files. The maintainer suggests inserting two lines in /usr/bin/R, LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:path-to-package/lib export LD_LIBRARY_PATH This works, but I felt more comfortable putting the first line in .Renviron or $R_HOME/etc/Renviron.site. However this doesn't seem to work, and I

Hi all, I'm having trouble connecting to an oracle database using RODBC under winXP. Unfortunately I can't really send a reproducable error as the initial call to odbcConnect seems to hangs R and I have to kill the session. I have been using RODBC to sucessfully connect to an MS Access DB that has tables linked through to the oracle database in question and that seems to work OK but it

Hello, I have a CentOS 5.5/64bit VM, where I only have sudo rights: afarber ALL=(ALL) NOPASSWD: ALL I'm trying to pass LD_LIBRARY_PATH through sudo to install DBD::Oracle ( https://rt.cpan.org/Ticket/Display.html?id=63678 ) and have tried using "sudo -E" and also changing these lines in the stock /etc/sudoers: Defaults !env_reset Defaults env_keep =

Hello Users: I'm using R version 2.0.1, and having problems with RODBC. Everything works fine when I use Rgui, but when I try to use Rterm and issue the commands library(RODBC) con <- odbcConnect("MySQL", "test") I get the following error: Error in sqlQuery(con, str) : first argument is not an open RODBC channel In addition: Warning messages: