He is multiple-posting: this was also posted on R-siq-db. Please do not answer here.

The R-sig-db moderator

On 27/05/2012 18:26, Michael wrote:
On Sun, May 27, 2012 at 11:32 AM, Michael<comtech....@gmail.com>  wrote:

Help! The R Console very quietly closed and exited without giving any
errors/warnings...after I loaded the RODBC library...

Loading required package: RODBC




On Sat, May 26, 2012 at 10:27 PM, Michael<comtech....@gmail.com>  wrote:

Hi all,

It's very strange. In RStudio, I can successfully load("RODBC"). But in
the plain R Console, I just couldn't get it work:

(For some special and important reasons, I have to make the RODBC work in
R Console, not the RStudio.)

At first, the some shared library "libodbc.so" couldn't be found... it's
right there, but R Console just couldn't find it.

I then find that the

Sys.getenv("LD_LIBRARY_PATH") is different for R Console vs. RStudio.

Weirdly, the LD_LIBRARY_PATH in RStudio even doesn't have any "ODBC"
terms/words in its long string...

I guess RStudio has some special configuration for RODBC, so it doesn't
require LD_LIBRARY_PATH to be set up for ODBC at all.

I then added the ODBC library path into the LD_LIBRARY_PATH in R Console.

I found that this problem is solved...

But then the R Console complained that the "ODBCINI" was set up correctly.

So I compared the "ODBCINI" in RStudio vs. "ODBCINI" in R Console, found
the R Console one seems to be missing.

I then copied the "ODBCINI" from RStudio and pasted it into R Console.

Now the load("RODBC") can run in the plain R Console, but then the whole
R console crashed without giving any errors/warnings...

It exited back to the shell prompt...

What can I do? Anybody please shed some lights on me on this?

Thanks a lot!




        [[alternative HTML version deleted]]

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.


--
Brian D. Ripley,                  rip...@stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to