R SIG Fedora - May 2012 - SOS! The R Console very quietly closed and exited without giving any errors/warnings...after I loaded the RODBC library...

Hi all,

Please pardon me for seemingly double-post.

I was referred to this r-sig-fedora mailing-list kindly by a member of
r-sig-db mailing-list... because my platform is Red Hat Enterprice.

Thank you!

---------------

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

Loading required package: RODBC

--------------

R Console closed and exited quietly after loading "RODBC"...

I suspect that's segment fault crash...

but how do I figure out what exactly is the problem? where can I find the
core dump?

Thanks a lot!

(but this doesn't occur when I use R in RStudio...)

----------------------------------------

On Sat, May 26, 2012 at 10:27 PM, Michael <comtech.usa@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]]